AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7599JZurro Roger M · Freehold, NJN7599KSimmons Dawson L Jr · Council, NCN7599RHoffman Harold O · Andrews, TXN759AKMichael Michael D · Soldotna, AKN759CACivil Air Patrol · Maxwell Afb, ALN759EEAcadiana Technical College · Lafayette, LAN759LBBrown Larry W · The Villages, FLN759STraining Planes LLC · Tampa, FLN75ALTeebagy Steven C · Wellington, FLN75ARRegistered aircraftN75BFScussel Edward D · Albuquerque, NMN75BNBernic Inc Trustee · Wilmington, DEN75BPPearce William R · Grants Pass, ORN75CEInternational Air Services Inc Trustee · Carson City, NVN75CJAngels Ten LLC · Norfolk, VAN75CMLowe Kenneth W · Sea Island, GAN75DCN18356 LLC · Hayden, IDN75DFShelley Michael D · Murfreesboro, TNN75ECMaxson Phillip W · Green Cove Springs, FLN75ELTipton Capital LLC · Tulsa, OKN75FFFf22 LLC · Scottsdale, AZN75GDCurren Scott N · Prospect, OHN75GKGrecor LLC · Ashville, ALN75GPCross Colton · Allons, TNN75HCCai Tech LLC · Greenwood, DEN75HDMorton Michael E · Hickory, NCN75HRMountain Flyer Aircraft LLC · Kalispell, MTN75HUAviat Aircraft Inc · Afton, WYN75HYDiversified Air LLC · Kalispell, MTN75JADomenick James V · Placitas, NMN75JGWhisenant Roy H II · Poway, CAN75JRWillis James R · Belleview, FLN75JWCompher Charles D · Berryville, VAN75KAmra Nabil W · Chaska, MNN75KAN75ka LLC · Fort Washington, MDN75KBJoseph Carter Realty Inc · Jasper, ALN75KJSeiter Gene G · Pleasant View, TNN75KMEverett Kevin · Peoria, ILN75KRRoss Kevin · Granbury, TXN75LLDavis Air LLC · Phoenix, AZN75MMDonney Tom J · Sturgis, SDN75NCRegistered aircraftN75NSJohnson Dale B · Steele, NDN75PAMadrid Michael J · Lompoc, CAN75PDHaher Thomas R · Tully, NYN75PLMccombs John W · Fairfax, VAN75RBBarr Air Patrol LLC · Mesquite, TXN75RESarasota Wings LLC · Nokomis, FLN75SDVimco N75sd LLC · El Paso, TXN75SEJansen Adam Roger · Sunnyvale, CA
Back to AD 81-18-04 R2