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.
N6144DCarter Tim R · Morgan, UTN6144LArtz Agri Sales LLC · Westhope, NDN6144MBargabos Richard O · Peterboro, NYN6144NDunn Rick · Benton, ARN6144VAir Flite Inc · Shawnee, OKN6144WFiebelkorn Daniel S · Gregory, SDN61455Hutcheson David Carl · Santa Rosa Beach, FLN61458Dls Holdings Inc · Lewes, DEN6145DLindsey Christopher T · Nesbit, MSN6145LMichaud Martin R · Monte Vista, CAN6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXN6145VMarshall University · Huntington, WVN6145WRegistered aircraftN61465Bishop Michael D · Pulaski, TNN61468Nimmons Johnny F · Brookshire, TXN6146PMount Up Aviation LLC · Kirbyville, MON6146QWisconsin Aviation-Four Lakes Inc · Madison, WIN61474Harper Analeasa Leighan · Clarksville, TNN6147DRegistered aircraftN6147EBuckley Michael J · Billings, MTN6147HBietsch Sr Thomas R · Lincoln, CAN6147MSix One North LLC · Anchorage, AKN6147RBloom James F · Clay City, KYN6147WLister Stephen J · Sherman, ILN61486Johnson Gary R · Carthage, NYN6148HHicks Braden · Manson, IAN6148JNorth Texas Flight Ventures LLC · Mckinney, TXN6148LYoukey John N · Yuma, AZN6148NAll-In-Aviation LLC · Paragould, ARN6148VChupp Aaron · Gallipolis, OHN6148WAir Ventures Flying School LLC · Smithfield, RIN6149Witek Edward G · El Cajon, CAN61494Millican Marc J · Anchorage, AKN614973 Dudes 1 Plane LLC · Olympia, WAN6149JAeroventures Flying Club Inc · Lilburn, GAN6149NZappa Tyler M · Hudson, FLN6149QGreen Airports Development Corp · Kemah, TXN6149SScheller Kenneth R · Glassport, PAN6149TCrawford Iain A · Perkinsville, VTN6149VFoode Frank J · Cordova, AKN614ACLawless Aviation LLC · Fishers, INN614AZWienholt Robert Jr · Perry Hall, MDN614BGNorth Star Aviation Inc · Mankato, MNN614BLWingsleasing LLC · Wichita, KSN614BREsch Brian D · Colorado Springs, CON614CGC3 Aircraft LLC · Burnet, TXN614DHHall Wilburn H · Fort Payne, ALN614DVSpano David · Oswego, ILN614ECEarwood Edward A · Sonora, TXN614EDClark Richard A · Warren, MI
Back to AD 81-18-04 R2