AD 97-25-07
Registered aircraft · 99
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:97-25-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-25-07')
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:97-25-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-25-07') 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.
N399CLBeta Fleet LLC · South Burlington, VTN413XJAviation Inventory Resources Inc · Alvarado, TXFirst renewal noticeN417XJBank Of Utah Trustee · Salt Lake City, UTN419CLLegends Cargo Aircraft LLC · Lakeland, FLN431BCJahn431bc LLC · Miami, FLN432CLLegends Cargo Aircraft LLC · Lakeland, FLN440CLBank Of Utah Trustee · Salt Lake City, UTN441FFAircraft Guaranty Corp Trustee · Oklahoma City, OKN44KSGo Vector One LLC · Pls Vrds Est, CAN458CLBank Of Utah Trustee · Salt Lake City, UTN481BCJahn481bc LLC · Miami, FLN492PHPhi Aviation LLC · Lafayette, LAN503JWBristow LLC · Lake Charles, LAN512EVBank Of Utah Trustee · Salt Lake City, UTN525BNBell Textron Inc · Fort Worth, TXN525BVBell Textron Inc · Fort Worth, TXN525TYBell Textron Inc · Fort Worth, TXN592PHPhi Aviation LLC · Lafayette, LAN595QAQuality Aviation LLC · Boulder, COFirst renewal noticeN63AUTurbo Lease LLC · Miami, FLN641BCIbc Airways Inc · Fort Lauderdale, FLN651BCAviation Inventory Resources Inc · Alvarado, TXN671BCIbc Airways Inc · Fort Lauderdale, FLN675PAAviation Inventory Resources Inc · Alvarado, TXN677PAAviation Inventory Resources Inc · Alvarado, TXN681BCAviation Inventory Resources Inc · Alvarado, TXN685PAAviation Inventory Resources Inc · Alvarado, TXN69EKnight Helo LLC · Wilmington, DEN725HTBank Of Utah Trustee · Salt Lake City, UTN726HTBank Of Utah Trustee · Salt Lake City, UTN745HBank Of Utah Trustee · Salt Lake City, UTN746HBank Of Utah Trustee · Salt Lake City, UTN80AUAurora Flight Sciences Corp · Manassas, VAN822HBank Of Utah Trustee · Salt Lake City, UTN823HBank Of Utah Trustee · Salt Lake City, UTN825FAQflight Corp · Kalispell, MTN825HBank Of Utah Trustee · Salt Lake City, UTN855PSVale Management Inc · Kalispell, MTN901BCAviation Inventory Resources Inc · Alvarado, TXN904AEAviation Inventory Resources Inc · Alvarado, TXN907RARyan Air Inc · Anchorage, AKN931BCBank Of Utah Trustee · Salt Lake City, UTN951BCJah2022a Saab340b Msn 318 LLC · Dallas, TXN95SATurbo Lease LLC · Miami, FLN961BCBank Of Utah Trustee · Salt Lake City, UTN968AFBank Of Utah Trustee · Salt Lake City, UTN971BCBank Of Utah Trustee · Salt Lake City, UTN985ESJah2022a Saab340b Msn 333 LLC · Dallas, TXN989AFBank Of Utah Trustee · Salt Lake City, UT
Back to AD 97-25-07