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.
N7578TPhysics Aviation LLC · Jonesboro, ARN757BGWallace Wayne W · Bristol, CTN757BPCommins Alfred D · Friday Harbor, WAN757DCLeon Hinkle LLC · Fort Ashby, WVN757DGHall Wesley W Trustee · Reno, NVN757DJPanepinto Lane P · Lafitte, LAN757GTGolf Tango LLC · Lubbock, TXN757HSRindlisbaker Chad · Pocatello, IDN757JWTary John G · Redondo Beach, CAN757PUAvs Aviation LLC · Williamsburg, VAN757RShepard Peter M · Wasilla, AKN757RJCenter Brian · Garwood, TXN757RSRegistered aircraftN757VYRice Timyn J · Saint Petersburg, FLN757XUHighflight Inc · Perkinsville, VTN757YGDayton Pilots Club Inc · Springboro, OHN7580NSparling George · Grand Prairie, TXN7580TBushgoair LLC · Chicago, ILN7581SFoxaire LLC · Austin, MNN7582HStiltner Sean · Piketon, OHN7582KErb Jason E · Barron, WIN7583KBaker Mark L · Murfreesboro, TNN7583SAir Anderson LLC · Dubuque, IAN7583WJoseph Kenneth W DBA · Canton, OHN7584NCarto Flight Inc · Willoughby, OHN7584SSanderson Jerome A · Fort Worth, TXN7584YMaher Andrew · Woodinville, WAN7585EKauffman Larry R · Auburn, WAN7585SHayes John Martin · Mcalester, OKN7586XDpair LLC · Rome, GAN7586YJaskoski Leo D · Avondale, AZN75870Westwind Aviation Inc · Phoenix, AZN7587SWerner Matthew J · Shiner, TXN758FCapital Aircraft LLC · Juneau, AKN7590NIventosch Leonard · Mccall, IDN7590SMoody Gene M · Kingsport, TNN7591NJones Michael D · Southern Pines, NCN7591SWildenberg Earl W · Menomonie, WIN7592SJld Aero Inc · Dalton, GAN7592YClover Park Technical College · Lakewood, WAN75935Allison Aviation LLC · Missoula, MTN7593ST-Craft Aero Club · Nampa, IDN7594MNcneill Dudley · Happy, TXN7594SGibbs John D · Victoria, TXN7596HMccrory James K · Bloomington, INN7596SLoftin Nathan E II · Pompano Beach, FLN7597SRainier Ranch LLC · Enumclaw, WAN7597XPlain Company Ltd · Bloomfield Hills, MIN7598SOz A&P LLC · Tifton, GAN7598ZCivil Air Patrol Inc · Maxwell Afb, AL
Back to AD 84-10-01 R1