AD 94-05-05 R1
Registered aircraft · 26,232
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.
N6994FHerring Jason D · Wasilla, AKN6994XVossler Kevin D · Bismarck, NDN6995EBennett Jeffrey S · La Mesa, CAN6995SNaylor Aviation LLC · Scotch Grove, IAN6995XWarmkessel James R · Felton, CAN69968Henrikson Peter R · Fort Worth, TXN6997AAirpower Aviation Resources Inc · Newbury Park, CAN6997FSmith Roger D · Fayetteville, NCN6998APincheon Reginald · La Vergne, TNN6998GAviation Trust Company LLC Trustee · Oklahoma City, OKN6998SFowler John C · Scott Depot, WVN6999AHartzler Jeffery A · Rittman, OHN6999EMusgrove Jimmy Wayne · Delta Junction, AKN6999FHabibi Airlines LLC · San Juan, PRN6999RWorswick Dwight D · Yuba City, CAN699RMars Christopher M · Mantua, OHN699TKStockton Clifford A · Anchorage, AKN69AMMargitan Allan R · Nine Mile Falls, WAN69GGMosher Dustin T · Tehachapi, CAN69HGPlane Fun Inc Tr Trustee · Snellville, GAN69HPHigh Performance Aircraft LLC · El Cajon, CAN69HWRoth Richard E · Appleton, WIN69JRMorgan Claude C Jr · Granada Hills, CAN69VStade Joel T · Iowa Park, TXN69ZBSpringfield Flying Service LLC · Columbia, CAN6EKCjh Aviation LLC · New Bern, NCN6EWThorne John S · Woodland Hills, CAN6JYYoung John B · Panacea, FLN6LKCollins Kyle L · Vallejo, CAN6MTSchwartz Amy A · Chandler, AZN6NDLind Mitchell W · Polk City, FLN6PJPoe Rick M · Mojave, CAN6XTBarrass John · Winter Garden, FLN6ZBAsh Reed · Atlanta, GAN7000AHaley Michael R · Hobbs, NMFirst renewal noticeN7000ESchweitzer Mark A · Susanville, CAN7000MWht LLC · Noonan, NDN7000TCarter Jared · Lebanon, TNN7001ALkp Aviation LLC · Montgomery, INN7001EMaupertuis Philippe F · Winchester, CAN7001GWhite Richard L · Pittsburgh, PAN7001HElmore Mason Brock · Frost, TXN7001MRush Michael J · Nashua, NHN7001XMoore Aviation Service LLC · Selma, ALN7002AAustin James M · Fort Worth, TXN7002EHickle William H · Inyokern, CAN7002FMcdonald Timothy M · Meredith, NHN7002MApte John W · Biddeford, MEN7003AHuang Sophie M · Newcastle, WAN7003EIndy Air Sales LLC · Anderson, IN
Back to AD 94-05-05 R1