AD 2017-19-20
Registered aircraft · 135
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:2017-19-20')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-20')
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:2017-19-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-20') 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.
N352CJAviation Inventory Resources Inc · Alvarado, TXN353SABank Of Utah Trustee · Salt Lake City, UTN361CLLegends Cargo Aircraft LLC · Lakeland, FLN362AGJahn362ag LLC · Miami, FLN364PXFloat Alaska Holdings LLC · Pomona, CAN369PXAviation Inventory Resources Inc · Alvarado, TXN385RSAeronave Corp · Kalispell, MTN390ALBank Of Utah Trustee · Salt Lake City, UTN391ALBank Of Utah Trustee · Salt Lake City, UTN392ALBank Of Utah Trustee · Salt Lake City, UTN392JSChevron USA Inc · Picayune, MSN392PHPhi Aviation LLC · Lafayette, LAN393ALBank Of Utah Trustee · Salt Lake City, UTN399CLBeta 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, OKN458CLBank Of Utah Trustee · Salt Lake City, UTN465VLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN481BCJahn481bc LLC · Miami, FLN492PHPhi Aviation LLC · Lafayette, LAN503JWBristow LLC · Lake Charles, LAN512EVBank Of Utah Trustee · Salt Lake City, UTN524PBBristow LLC · Lake Charles, LAN525BNBell Textron Inc · Fort Worth, TXN525BVBell Textron Inc · Fort Worth, TXN525TYBell Textron Inc · Fort Worth, TXN592BGBristow US LLC · New Iberia, LAN592PHPhi Aviation LLC · Lafayette, LAN595QAQuality Aviation LLC · Boulder, COFirst renewal noticeN63AUTurbo Lease LLC · Miami, FLN641BCIbc Airways Inc · Fort Lauderdale, FLN651BCAviation Inventory Resources Inc · Alvarado, TXN675PAAviation Inventory Resources Inc · Alvarado, TXN677PAAviation Inventory Resources Inc · Alvarado, TXN685PAAviation Inventory Resources Inc · Alvarado, TXN692BGBristow U S LLC · New Iberia, LAN69EKnight 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, UTN803CNSikorsky Aircraft Corp · Stratford, CTN806APBristow LLC · Lake Charles, LAN80AUAurora Flight Sciences Corp · Manassas, VAN822HBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2017-19-20