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.
N68DGDellar Randy Roger · Wasilla, AKN68DSSichak Stephen Jr · Wanaque, NJN68DWAero Group I LLC · Woodstock, VAN68DZUsda Aphis-Ws · Cedar City, UTN68EEBurtt John B · Pierson, MIN68FSistrunk Donald M · Ragley, LAN68FDVargas Emmanuel N · Murrieta, CAN68FFPeregrine Howard Partners II Lp · New Orleans, LAN68GJDc Foote & Associates Inc · Camarillo, CAN68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN68HKPomeroy Andy Lee · Seattle, WAN68JBOtto Pilot LLC · Everett, WAN68JCCapps Jon T · Bentonville, ARN68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingN68JXRybarczyk Thomas B · Benton, KSN68JYHowell Jon · Texarkana, ARN68KAAakre Keith E · Granite Falls, MNN68KBKeller Bros Airport Inc · Lebanon, PAN68KFDelconte Anthony T · Old Hickory, TNN68KTHobein Ted · Wheaton, ILN68KWKim Waters Inc · Gainesville, GAN68LCDriver Matthew · Rio Rancho, NMN68LHGottschall James W · Highland, WIN68LKKing Larry E Jr · Wenatchee, WAN68LRMs Aero Inc · Lakeville, OHN68MABig Creek Flyers LLC · Lewes, DEN68MCAlpha Enterprises · Burley, IDN68MEPeigneux Brothers Llp · Malta, MTN68NDSand Nicholas Patrick · Alta, IAN68PJOdonnell Paul E · Schuylerville, NYN68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKN68QCobb Lee C · Van Alstyne, TXN68RLeroy Philippe G · Willcox, AZN68RLSlutz David E · Morristown, TNN68RRBaker Nelson J · Ocean City, NJN68RSAlston Walter III · Fernandina Beach, FLN68RVSteed David A · Oklahoma City, OKN68SBLucey William E · Salisbury, NCN68SCBridges Lee P · Smithville, TNN68SDPro Aero LLC · Warrenton, VAN68SVAviat Aircraft Inc · Afton, WYN68TLShoenberger James · Orlando, FLN68TYKing Ty · Rogers, ARN68VCammack Daniel P · Colorado Springs, CON68VAAspen Helicopters Inc · Oxnard, CAN68VEK F Aviation Inc · San Juan, PRN68VRGene Coleman Machine Inc · Menominee, MIN68VVWhite Mark E · Charleston, WVN68WLGlobal Pilot Inc · Wilmington, DEN68WPButseev Anthony · Tarzana, CA
Back to AD 81-18-04 R2