AD 2011-19-03
Registered aircraft · 112
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:2011-19-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-03')
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:2011-19-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-19-03') 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.
N392ALBank Of Utah Trustee · Salt Lake City, UTN392JSChevron USA Inc · Picayune, MSN392PHPhi Aviation LLC · Lafayette, LAN393ALBank Of Utah Trustee · Salt Lake City, UTN413XJAviation Inventory Resources Inc · Alvarado, TXFirst renewal noticeN417XJBank Of Utah Trustee · Salt Lake City, UTN431BCJahn431bc LLC · Miami, FLN465VLTvpx 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, TXN677PAAviation 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, UTN823HBank Of Utah Trustee · Salt Lake City, UTN825FAQflight Corp · Kalispell, MTN825HBank Of Utah Trustee · Salt Lake City, UTN851ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN855PSVale Management Inc · Kalispell, MTN904AEAviation Inventory Resources Inc · Alvarado, TXN917CBNorth Slope Borough · Barrow, AKN920VHBristow US LLC · New Iberia, LAN921GLChevron U S A Inc · Picayune, MSN922BHPhi Aviation LLC · Lafayette, LAN925PHPhi Aviation LLC · Lafayette, LAN927SCChevron USA Inc · Picayune, MSN929PHU S Bank Na · Marshall, MNN92EHBristow LLC · Lake Charles, LAN931PHPhi Aviation LLC · Lafayette, LAN935PHPhi Aviation LLC · Lafayette, LAN936PHBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2011-19-03