AD 2003-08-52
Registered aircraft · 92
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:2003-08-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-08-52')
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:2003-08-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-08-52') 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.
N417XJBank 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, 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, TXN675PAAviation Inventory Resources Inc · Alvarado, TXN677PAAviation 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, MTN904AEAviation Inventory Resources Inc · Alvarado, TXN931BCBank 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 2003-08-52