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.
N700BZBliss Robert Z · New York, NYN700CDCrahen William F · Merrimac, WIN700CNHoleshot Aviation LLC · Lodi, CAN700CROneglia Francis G · Hawthorne, FLN700CXEmerald City Aircraft Leasing Inc · Port Orchard, WAN700DJRegistered aircraftN700DLArthur Aaron · Gold River, CAN700DRRadwanski D · Westmont, ILN700ECInglis Scott D · Incline Village, NVN700EEMatteo Properties Inc · Wickliffe, OHN700FMWahl Mark E · Oswego, NYN700GPHenderson Donald P · Lagrange, GAN700HHHubbell Jonathan E · Mccordsville, INN700JLHubbell Jonathan E · Mccordsville, INN700KRStrange Jim · Tyler, TXN700MGGeorgia Aviation Authority · Eastman, GAN700MWSome Beech LLC · Bolivar, MON700PAW Patrick Enterprises Inc · Wilmington, DEN700PJShort Stephen A · Lake Placid, NYN700PMRar LLC · Louisville, KYN700RLGonzalez Richard J · Granbury, TXN700RVIngram Ronald W · Springfield, ILN700SDTms Aviation LLC · Bon Aqua, TNN700SEBooze Conrad C · Warner Robins, GAN700TCTek Aire LLC · Blacklick, OHN700TEAustin Bill DBA · Sparta, TNN700TPCreedon Robert A · Lompoc, CAN700WGNeuro Endovascular Services And Technology LLC · Palm Harbor, FLN700WNSundstrom Steven L · Friendswood, TXN700WPLebus Jack G · Longview, TXN700XRj Air LLC · Longwood, FLN700YMKisthard James · Roberts, MTN700YPDelta Delta LLC · Fargo, NDN700YSSchwietz Thomas E · Strasburg, VAN7010BDurfee Tristan O · Duluth, MNN7010GStavair LLC · Gulf Breeze, FLN7010KWiechmann Caleb · Prairie City, SDN7010PJuliett Tango LLC · West Rutland, VTN7010QMosman Matthew J · Nezperce, IDN7010SNass Michael F · Clinton, IAN7010VCompass Aviation Maintenance LLC · Shelby, NCN7010WBrown Nicholas R · Knoxville, TNN7010YBrown William C Jr · Northville, MIN7011BFuller Eddy A · Madras, ORN7011DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LAN7011GChase Development Aviation LLC · Oakland Park, FLN7011JSouthlake Aviation LLC · Arden, NCN7011KYoung Carl Jason · Lubbock, TXN7011PJapikse Bert · Pawleys Island, SCN7011WLevine Allen D Trustee · Goshen, NY
Back to AD 81-18-04 R2