AD 91-10-01
Registered aircraft · 249
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:91-10-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-10-01')
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:91-10-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-10-01') 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.
N340RCConsumer Aviation Inc · Springfield, MON342JCAviation Investments Inc · Redondo Beach, CAN346AGBank Of Utah Trustee · Salt Lake City, UTN346CJBank Of Utah Trustee · Salt Lake City, UTN348AGAviation Inventory Resources Inc · Alvarado, TXN34HGUnited States Government · Fort Belvoir, VAN351AGBank Of Utah Trustee · Salt Lake City, UTN351TATrans Executive Airlines Of Hawaii Inc · Honolulu, HIN352CJAviation Inventory Resources Inc · Alvarado, TXN353PAAersale Inc · Coral Gables, FLN353SABank Of Utah Trustee · Salt Lake City, UTN355CLRegistration Pending · Statesville, NCRegistration pendingN360ABAcc Integrated Services Inc · Milwaukee, WIN361CLLegends Cargo Aircraft LLC · Lakeland, FLN362AGJahn362ag LLC · Miami, FLN364PXFloat Alaska Holdings LLC · Pomona, CAN367ACAcc Integrated Services Inc · Milwaukee, WIN367MQAcc Integrated Services Inc · Milwaukee, WIN369PXAviation Inventory Resources Inc · Alvarado, TXN377MQAcc Integrated Services Inc · Milwaukee, WIN378MQAir Cargo Carriers LLC · Milwaukee, WIN381MQAcc Integrated Services Inc · Milwaukee, WIN382MQAcc Integrated Services Inc · Milwaukee, WIN383MQAcc Integrated Services Inc · Milwaukee, WIN385MQAcc Integrated Services Inc · Milwaukee, WIN391RCIal Corp · Lewes, DEN399CLBeta Fleet LLC · South Burlington, VTN413XJAviation Inventory Resources Inc · Alvarado, TXFirst renewal noticeN417XJBank Of Utah Trustee · Salt Lake City, UTN419CLLegends Cargo Aircraft LLC · Lakeland, FLN422BNAntares Aviation LLC · Boca Raton, FLN427PEAcc Integrated Services Inc · Milwaukee, WIN431BCJahn431bc LLC · Miami, FLN432CLLegends Cargo Aircraft LLC · Lakeland, FLN438AAFrontera Flight Holding Inc · Dover, DEN438BNAntares Aviation LLC · Boca Raton, FLN440CLBank Of Utah Trustee · Salt Lake City, UTN441FFAircraft Guaranty Corp Trustee · Oklahoma City, OKN44503Frontera Flight Holdings Inc · Dover, DEN458CLBank Of Utah Trustee · Salt Lake City, UTN471EVGugu Ltd · Bellevue, WAN472EVFletcher Aviation Services LLC · Bismarck, NDN481BCJahn481bc LLC · Miami, FLN482AAArctic One LLC · Fairbanks, AKN483AArctic One LLC · Fairbanks, AKN492AKWin Win Aviation Inc · Wake Forest, NCN502DADodson International Parts Inc · Rantoul, KSN53993United States Government · Fort Belvoir, VAFirst renewal noticeN553AAFrontera Flight Holdings Inc · Dover, DEN556AAFrontera Flight Holding Inc · Dover, DE
Back to AD 91-10-01