AD 2017-20-06
Registered aircraft · 364
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-20-06')
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-20-06')
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-20-06') 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-20-06') 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.
N308JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN309JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN30QAWood Asg LLC · Carrollton, TXN310VZRan Air LLC · Driggs, IDN311FCWheels Up Partners LLC · New York, NYN311GSCh Aircraft LLC · Palm Beach, FLN313DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN313VClyde Companies Inc · Orem, UTN314JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN316CSCaroler 316 LLC · Solon, OHN317VBVictor Bravo Air LLC · Dallas, TXN31CAHf Sinclair Payroll Services Inc · Dallas, TXN320JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN320LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN325PEPeco Air LLC · Park City, UTN325TGFlying G Aviation LLC · Atlanta, GAN325WJDorado Aircraft Leasing LLC · Jupiter, FLN328RSHolloman Ventures Aviation LLC · Houston, TXN330PJKhcl LLC · Cincinnati, OHN330SAThree Feathers Logistics LLC · Atlanta, GAN330ZAMead Gregory Zane · Lubbock, TXN3337JBig Horns Leasing LLC · Jackson, WYN334AFSusieair LLC · Houston, TXN335AFArcadia Leasing LLC · Arcadia, WIN338JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN339BVAljobe Bajeky LLC · Levittown, NYN33CHRitz Air LLC · Dayton, OHN340JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN345HGAxios Aviation LLC · Traverse City, MIN347KKiewit Engineering Group Inc · Omaha, NEN350XXPete Mitchell Aviation LLC · Plantation, FLN353PCQuantum Aviation LLC · Tampa, FLN354WGAutomatic Press LLC · Horseshoe Bay, TXN356MLAviation Travel Ventures LLC · Melbourne, FLN357KGN357kg LLC · Bluffton, SCN357TWLazer Aviation LLC · Orange Park, FLN35FEFederal Express Leasing Corp · Memphis, TNN362JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN362LRegistered aircraftN365LRegistered aircraftN370DBCitation X Parts LLC · Liberty, NCN370ELLge Management Partners LLC · Phoenix, AZN371DBCitation X Parts LLC · Liberty, NCN371JGNih-Aviation LLC · Charlotte, NCN372DBCitation X Parts LLC · Liberty, NCN373DBCitation X Parts LLC · Liberty, NCN377DPOrr Investments LLC · Casper, WYN377MDCambria Aviation LLC · Belle Plaine, MNN377RUCmmr Enterprise LLC · Round Top, TX
Back to AD 2017-20-06