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.
N228LWhite Plains Aviation LLC · Saratoga Springs, NYN228YAnderson Equipment Co · Latrobe, PAN22XZSaetta LLC · Lehi, UTN235EFEaf Air LLC · Detroit, MIN245AEN318mm LLC · Topeka, KSN247FSNcm Leasing LLC · Naples, FLN248MLMglctt Inc · Raleigh, NCN24FEFederal Express Leasing Corp · Memphis, TNN2510DD Squared Ventures LLC · Scottsdale, AZN251FTSc Aviation Partners LLC · Boston, MAN256GGChantilly Crushed Stone Inc · Chantilly, VAN256WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN265KCorporate Jet Leasing Co LLC · Wichita, KSN265SJN529tm LLC · Fairfax, VAN267620407 Holdings LLC · Atlanta, GAN26FAFreymiller Aviation LLC · Oklahoma City, OKN26FEFederal Express Leasing Corp · Memphis, TNN272JGRegistered aircraftN283BRanger Air LLC · Kinston, NCN286JRTf 286 LLC · Torrance, CAN286MHPowerhouse Equipment Leasing LLC · Camden, DEN28FEFederal Express Leasing Corp · Memphis, TNN290CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN290CLJs Leasing LLC · Frisco, TXN293HCHampton Cattle Co LLC · Orlando, FLN299TSTsi Equipment Leasing LLC · Spokane, WAN300JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN300KCKroger Co · Cincinnati, OHN300KEOneok Inc · Tulsa, OKN300KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN300LVCapital Challenge LLC · Reno, NVN300NJFrazier Aviation LLC · Corpus Christi, TXN300NZTvpx Ars Inc Trustee · Concord, MAN300RLBbl Aviation LLC · Scottsdale, AZN300TUFlying Amici Aviation LLC · Owasso, OKN301JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN301JLRegistered aircraftN302JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN302KCorporate Jet Leasing Co LLC · Wichita, KSN302KCKroger Co · Cincinnati, OHN302LTAsig Aviation Partners LLC · Dover, DEN302PEBank Of Utah Trustee · Salt Lake City, UTN303JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN304KCKroger Co · Cincinnati, OHN304RJHaystack Jmr LLC · Irvine, CAN305WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN306MFUmb Bank Na Trustee · Salt Lake City, UTN306WBJ & R Airways LLC · Lincoln, ALN307JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN307JWFinch Lawrence G · Moraga, CA
Back to AD 2017-20-06