AD 84-10-01 R1
Registered aircraft · 20,481
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.
N8730THardin Mark A · Dalton, GAN8731QHinlein Erich S · Pelham, MAN8731TSkol Alaska LLC · Soldotna, AKN8731XKabat Jules M · Las Vegas, NVN8732XHangar 2 Air LLC · Fort Collins, CON8732ZZiprik Russell L · Ball Ground, GAN8733XLaw Offices Of Brent M Ferrel LLC · Albuquerque, NMN8733ZTerway William · Wilsonville, ORN8734TSkimt Aviation LLC · Teaneck, NJN8734ZHardin Matthew W · Rutherford, CAN8735ZMcgarity Justin D · Paragould, ARN8736QCourtney Aviation LLC · Columbia, CAN8736XBoggio Richard E · Bradenville, PAN8737TSchmitt Gary W · Highlands, NCN8739TScranton Brian J · Ridgway, CON873CPCivil Air Patrol · Maxwell Afb, ALN873MBKumar Ravin · Carson, CAN8740QHampton Harvey E · Simms, MTN8740XUnwrapped LLC · Dover, DEN8741TTolman Jeremy Charles · Mcalester, OKN8742XGarletts Frank A · Jackson, MSN8744TEdhlund Joseph W · Brush Prairie, WAN8745XScott William R · Monroe, GAN8746XBlack Kevin R · Massillon, OHN8747XJodoin Michael G · Belton, SCN8748TDennis Richard E · Gakona, AKN874DTN874dt LLC · Canadensis, PAN8752TTortorige Carl J · Quincy, ILN8752XSmith Timothy R · Auburn, CAN8753TZaccheo Vincent S · Ulster Park, NYN8753ZBloated Armadillo Adventures Corp · Wilmington, DEN8754QD2 Holdings LLC · Salt Lake City, UTN8754TBurrington Steven A · Austin, TXN8754XSutton Aircraft Salvage LLC · Palmer, AKN8754ZBwana Z Transporation LLC · Missoula, MTN8755QMartensen Marten · Anchorage, AKN8756QTriple 2 LLC · Burlington, CON8756XGabelli Casey · Ridge Manor, FLN8758QBerge Christian · Mccall, IDN8758ZBellows Paul F · Vancouver, WAN8759TBlack Clifton D · Newnan, GAN8759XGrald Jonathan A · Goshen, NYN8759ZHelin Bruce A Trustee · Flagstaff, AZN875CPCivil Air Patrol · Maxwell Afb, ALN875PJVan Bortel Aircraft Inc · Arlington, TXN8760TMccandless Aviation LLC · Omaha, NEN8761TProsystems Consulting LLC · Saguache, CON8761ZHaag Walter G · Fall City, WAN8762TCrook Brady G · Bandon, ORN8763QArtic Backcountry Flying Service LLC · Kotzebue, AK
Back to AD 84-10-01 R1