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.
N7668DDorsey Keith W · Isabel, SDN7668FAdams Carl · Vincennes, INN7668SJacobson Luke W · Reno, NVN7668WGhahramanians Serjik · Sunland, CAN76695Keyte Clinton W · Colfax, CAN7669DSims Charles A · Chugiak, AKN7669GWingsleasing LLC · Wichita, KSN7669POkst George S · Slate Hill, NYN7669RSpence Lisa A · Houston, TXFirst renewal noticeN766AAtp Aircraft 6 LLC · Wilmington, DEN766CPCity Of Cleveland · Cleveland, OHN766DHHopper Daniel H · Walton, INN766FEdge Logistics Inc · South Lake, TXN766GAtp Aircraft 9 LLC · Wilmington, DEN766LAN766la LLC · Philadelphia, PAN766LMChopchop LLC · Stillwater, OKN766MFPinto Raymond A · Edgewater, FLN766NDGfk Wings LLC · Grand Forks, NDN766RCos LLC · Monument, CON766TWBarr Air Patrol LLC · Mesquite, TXN766WTrafford John-Tristan G · Brighton, MIN766WMOcean Aerial Ads Inc · Ocean City, MDN76707Harrison William S · Hernando, MSN7670FAkaya LLC · Sherman Oaks, CAN7670GPremier Aviation LLC · Philadelphia, MSN7670HRobinson Eric C · Palmer, AKN7670KRoss Mark Eric · Polson, MTN7670PSale Reported · Edenton, NCSale reportedN7670RMescher John A · Coldwater, OHN7670SShortridge Randall R · Mesa, AZN7670WSergeant Chess M · Dothan, ALN7671DMartin James P · Sioux City, IAN7671HAir Dakota Flite Inc · Hettinger, NDN7671RBeloiu Matei A · Fort Jones, CAN7671SKlos Aero LLC · Plevna, MTN7671YBailey Wryan T · Nashville, TNN7672JWeiner Johannes · New Paltz, NYN7672KWare Jake · Bovina, TXN7672PSantore William F · Laguna Niguel, CAN7672SLouisville Soaring Club Inc · Lexington, KYN7672WCrossroads Aviation LLC · Leesville, LAN7672YBertrand Jason · Seattle, WAN7673GSchaack Lawrence A · Woods Cross, UTN7673PR M Kraft Ag Inc · Cut Bank, MTN7673RGiles Dwight L · Greeley, CON7673WNew Horizons Aviation Inc · Goshen, INN7674CFiyalko Wayne · Fort Myers, FLN7674FCarter Rhonda L · Columbiana, ALN7674HOverly Terrence L · Tok, AKN7674JAerofeather Aviation Inc · Suffolk, VA
Back to AD 81-18-04 R2