AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N3557TRoberts Calvin D · Bluebell, UTN3557VMonahan Mary D · Independence, MNN35589Bracale Glenn S · Anchorage, AKFirst renewal noticeN3558JMenke Scot R · Stephenson, MIN3559VArmstrong Scott T · Navasota, TXN355BBarker Clyde · Pflugerville, TXN355EGunsch Matthew T · Phoenix, AZN35601Stinnett Spencer P · Athens, ALN3560CCarlson Michael W · Rockford, ILN3560HBlakley Jordan A · Lake Point, UTN3561CSand John C · Menomonie, WIN3561JApostolic Bible Institute Inc · Saint Paul, MNN3561KMoncus James R III · Birmingham, ALN3561SMunoz Christian · Visalia, CAN3561TBasye Matthew P · Delta Junction, AKN35622Bailey Carlton D Jr · Huntington, WVN35625Houten Jared C · Oro Valley, AZN3562SSpeedstar Aviation LLC · Kalispell, MTN3562VLifland Kenneth D · Lowry Crossing, TXN3563HBoelman Scott · Whittier, CAN3563LMartinez Guillermo E · Upland, CAN3563TBiornstad John A · Big Lake, AKN3564CMoe William A · Marysville, CAN3564HPittinger Sandra Lee · Beggs, OKN3564SMedlin Wayne D · Marshville, NCN3564TMoore David · Anchorage, AKN3565CBaumgartner Terry L · Lowell, MIN3565DJpn LLC · Park City, MTN3565SMarks David A · Madisonville, KYN3565TBamford Bert W · Wasilla, AKN3565VStein Anthony J · Locust Grove, GAN3566CJones Barton F · Colorado Springs, CON3566SBussio Michael B · Reno, NVN3566TLee Ryan D · Anchorage, AKN3566VMbsp Enterprises Inc · Wilmington, DEN3567CGrantham George F · Bush, LAN3567JMilne Pamela · Beaverton, ORN3567KYandik Stephen E · Hudson, NYN3567SKling Ronald L · Kimberling City, MON3568CBourgoine Richard A · Conesus, NYN3568JArmstrong Kevin L · Corvallis, ORN3568SKnitter Edward R III · Perry, NYN3568TSemmig Jeffrey C · Oceanside, CAN3569TGlines Levi G · Smithwick, SDN356CDKatabatic Engineering LLC · Auke Bay, AKN3570KSwickard William E · Kent, WAN3570SVance Douglas E · Cleveland, GAN3571DSmith Brant C · Anchorage, AKN3571SGoodman James L · Wray, GAN3571TRegistration Pending · Palmer, AKRegistration pending
Back to AD 94-05-05 R1