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.
N4254VJohnston Daniel T · Cambridge, OHN42557Kansas Taildraggers LLC · Lawrence, KSN42559Pilgrim Samuel W III · Tyrone, GAN4255YSkibinski Aaron R · Newnan, GAN4256EPaquette Denis J · Sioux Falls, SDN4256LStewart Stephanie J · Lakeland, GAN4256UGjm Aviation LLC · Petal, MSN4257NTurnage Brody G · Weatherford, TXN42586Petrosius Joseph D · Visalia, CAN4258EManning Richard F Jr · Midway, GAN4259FGuynes Ronald A · Two Rivers, WIN4259LBrown Lawrence D · Memphis, TNN4259NBergeron Daniel M · Dickinson, TXN4259VKurt Robert F · Rose Hill, KSN42602Hyatt Philip D · Gadsden, ALN4260FAyers Frank E · Coulee Dam, WAN4260LTrueman Jeffrey A · Clear, AKN4260UGebhart Travis D · Meadow, SDN4260VFranks Marvin L · Cedar Key, FLN4261Aero Missions Inc · Sylacauga, ALN42617Brandes Ryan · Zapata, TXN4261FPeri Richard A · Burgess, VAN4261LCochrane Warren H Jr · Carabaset Vly, MEN4261VWells Bryan G · Stephenville, TXN4262CJeffreis Christopher L · Edmonton, KYN4262FHayton James B · Sedro Woolley, WAN4262NCapps Steve · Newcastle, OKN4262UCrump Matthew A · Weatherford, TXN4262VKinzie Industries LLC · Alva, OKN4263LCox Dennis J · Beach City, TXN4263NHerold Robert D · Tallahassee, FLN4263UAdam Johnson · Sunray, TXN4263VUltra Flight LLC · Le Mars, IAN4264LMcguckin Michael C · Mesa, AZN4264UJones Craig R · Brighton, MIN4264VLubben Ryan D · Fergus Falls, MNN42658Keegel Michael D · Sanford, NCN4265CHunt Delbert O · Dillon, MTN4265FRedding Steven R · Skiatook, OKN4265L1515 Aviation LLC · Burleson, TXN4265VByler Jonathan P · Inman, SCN4265XMarshall George T · Santa Rosa, CAN42663Roland Ronald W Trustee · Mckinney, TXN4266FCape Fear Aviation Maintenance LLC · Fayetteville, NCN4266NBischof Timothy C · Port Orange, FLN4266UDoyle Paddy B · Homedale, IDN4267Gabel William B · Saint Joseph, TNN42679Robertson Nathan M · Acworth, GAN4267FValenzuela Kevin · Totowa, NJN4267NClark William M · Ann Arbor, MI
Back to AD 94-05-05 R1