AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N4657FDoxsee Arthur B · Bennington, VTN4658ALerner Michael M · Tehachapi, CAN4658FSedrel Steven M · Sparks, NVN465AMN465am LLC · Hollis, NHN465CGApogee Air LLC · Newark, CAN465CTMatter Terrence K · Reno, NVN465HMMorse Don W DBA · Priest Lake, IDN465TByrds Wholesale Inc · Clayton, NCN4660AConnealy Air LLC · Whitman, NEN4660BEllison Orlo T · Broomfield, CON4660CToudouze John M · La Vernia, TXN4660JStuder Al C · Shelby, MIN4660KFoster Gary Paul · Willow, AKN4660NCasey Kellie M DBA · Fort Worth, TXN4661AOlson Eric T · Hudson, WIN4661TPowell Christopher T · Moosic, PAN4661ZRustair Inc · Anchorage, AKN4662EJgm Aviation LLC · Marion, MTFirst renewal noticeN4662UMeadow Lakes Aviation · Wasilla, AKN4664BSaner Kim K · Soldotna, AKN4665ARegistered aircraftN4665CKrissman Ryan · Gallup, NMN4666BStanfield Francis T · Anchorage, AKN4666UParadise Adventures LLC · Glenburn, MEN4667KFletcher Mountain Aviation LLC · Hampden, MEN46686Skites Ronald W · Salome, AZN4669BDunbar Timothy C · Mukwonago, WIN4670KMaloy Steven · Andrews, NCN4671BFallin Zachary R · Oracle, AZN4672ARupert Angus H · Pensacola, FLN4672BHone Christopher J · South Cle Elum, WAN4672FWilmeth Roy · Frankston, TXN4673BRacoon Aviation LLC · San Antonio, TXN4673FCody Richard A · Mclean, VAN4673NSimla Properties LLC · Casa Grande, AZN4673UStephl Chris L · Soldotna, AKN4674EMilliken Bradley B · San Mateo, CAN4674UKlein David · Sebastopol, CAN4675ERojo Aircraft LLC · Mesquite, NVN4676BRobbins J Putnam · Valparaiso, INN4677QDahl Larry A · Cogswell, NDN4678BKing Paul E · Albany, ORN4678FMullett Sean · Cleveland, TNN4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4678TRothberg Diane Lee · Gainesville, GAN4679AFlying Bulldogs LLC · Joplin, MON4679UNelson Ross R · Menomonie, WIN4679YExtreme Air LLC · Cottage Grove, WIN467DHLopez Floyd W · Arroyo Seco, NM
Back to AD 84-10-01 R1