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.
N591PTRegistered aircraftN591RVSims David L · Mc Alpin, FLN591TXSchechter Andrew M · Goshen, OHN591VUVu Anh · Fredericksburg, VAN5920DBates Matthew T · Springfield, VAN5920HZakrzewski Patrick J · Waterford, WIN5920LSharratt Mark M · Ogilvie, MNN5920QKellogg Annabelle S · Cumming, GAN5920WSynergy Aviation LLC · Greer, SCN5921HHoehne Michael G · Vienna, VAN5921PFiscus Ryan K · Burleson, TXN5921WStearns Edwin Ben Jr · Eloy, AZN5922EAerial Scouting Solutions LLC · Sioux Center, IAN5922FNeel Aviation LLC · Lakeland, FLN5922HGifford Gary W · Lighthouse Point, FLN5922LJokerst Kenneth · Saint Louis, MON5922PWiseman Transport LLC · Henderson, TXN5922UPagan Jose A · Kokomo, INN5922ZBellamy John Mark · Freeville, NYN5923LKane Christopher M · Sacred Heart, MNN5923WPremier Pilots LLC · Herriman, UTN5924FN5924f LLC · Cocoa, FLN5924PPope Mark I · Arco, IDN5924QWright Andrew · Sacramento, CAN5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILN5924WPribbenow Dennis A · Payson, AZN59262Tabbert William Stanley · Diamondhead, MSN5926BAddington Ralph P · Orlando, FLN5926DToste Greg · Newcastle, CAN5926FRegistered aircraftN5926UIron Flyer Of Cuzamil LLC · Lewes, DEN5926WLeonard Jeffrey A · Bakersfield, CAN5927HParley Michael D · Carmel, CAN5927LTri State Airmotive LLC · Berryville, ARN5927PSchlup John R · Booneville, ARN5927WKochling Christopher · Houston, TXN5928EGace Flying Club Inc · Ronkonkoma, NYN5928JParsons Royson A · Atascadero, CAN5928QSchmidt Tyren A · Albertville, MNN5928WRegistered aircraftN-number assigned, not yet registeredN5929TFlight School Of Gwinnett Inc · Lawrenceville, GAN5929WEdwards Allan · Leesburg, VAN5929ZBrown Dave M · Crescent City, CAN592CJAims Community College · Greeley, CON592CPCivil Air Patrol · Maxwell Afb, ALN592DJFandango Ranch Operating Co Inc · Anacortes, WAN592FLGrey Rose Air LLC · Edenton, NCN592JSStraut James M · Upper Saddle River, NJN592KAtp Aircraft 3 LLC · Wilmington, DEN592MBIngle Allen B · Goldsboro, NC
Back to AD 81-18-04 R2