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.
N9303NWings Over Texas Holdings LLC · Denton, TXN9304DKenneson Robert P DBA · Eureka, KSN9304HWischmeyer Matthew R · Hopewell Junction, NYN9304LBraithwaite Lester T · Camino, CAN9304MSweeney William B · Leesville, LAN9304TPiper Aircraft Inc · Vero Beach, FLN9304WBark N Bite Aviators LLC · Sedona, AZN9305KHitech Aerospace Corp · New York, NYN9305LSutphin Harold W · Saint Cloud, FLN9305MSouthern Aircraft Consultancy Inc Trustee · Casper, WYN9305NRancho Av Leasing LLC · Temecula, CAN9305PJochim Mark A · Evansville, INN9305WKirby Rick D · Kimball, NEN9305YN9305y LLC · Wichita, KSN9305ZRegistration Pending · Keizer, ORRegistration pendingN9306HAnycomm Corp · Gold River, CAN9306JHanna Jr Charles W · Kingstree, SCN9306LRobinson Mark V · Vacaville, CAN9306MV1 Consulting Co · Crestwood, KYN9306VWilliams Steven M · Redwood, NYN93078Black Cat Aviation LLC · Centennial, CON9307DAviatzone LLC · Fort Lauderdale, FLN9307JWilliams Austen T · Fort Worth, TXN9307MCassling Edward F · Newark Valley, NYN9307SRearick Scott P · Frederick, MDN9307WHedgers Thomas W · Lino Lakes, MNN93082Schweiger Nathaniel A · Richland, WAN93085Hoffsette Dianna L Trustee · Saint Catharine, MON9308JYoung Ashley G · Lexington, NCN9308LRegistration Pending · Horn Lake, MSRegistration pendingN9308MDegraaf Derrick B · Manteca, CAN9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCN9308VDapaah Seth O · Upper Marlboro, MDN9308WHubbard Manu L · Riverside, CAN93096Ngumba Andrew N · Long Beach, CAN9309CVan Bortel Aircraft Inc · Arlington, TXN9309KVera Rojas Guillermo A · Albuquerque, NMN930AMDel Mar College · Corpus Christi, TXN930CPCivil Air Patrol · Maxwell Afb, ALN930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeN930GFThierry Robert J · Pottstown, PAN930LTAerosim Flight Academy · Sanford, FLN930MCook Christopher K · Wintersville, OHN930MAPlaceway Scott M · Lapeer, MIN930RJN147sb LLC · Cortland, NYN930TEPeters James L · Lindon, UTN9310DRegistered aircraftN9310HLilienthal Donald W · Cyrus, MNN9310JBuckwalter Russell · Broadway, VAN9310LGavitte Peter F · Napa, CA
Back to AD 81-18-04 R2