AD 2017-20-01
Registered aircraft · 341
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-01')
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-01')
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-01') 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-01') 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.
N222NEHigher Cause LLC · Grand Rapids, MIN224JL205 Flintstones LLC · Flint, MIN229LJN229lj LLC · Bentonville, ARN22CPRegistered aircraftN241LJDouble Whiskey Aviation LLC · Midland, TXN244CKKalitta Air LLC · Ypsilanti, MIN248BPNorth Valley Air Ltd · St Thomas, VIN24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLN250EXAb Aspen LLC · Opa Locka, FLN253SCPowderhorn Aviation LLC · Bethany, OKN254ALCorsair Two LLC · Hillsboro, ORN254FSS&S Aviation Management LLC · Waco, TXN254SBHawker 800xp LLC · Fort Lauderdale, FLN258UTBurnt Orange Five LLC · Seabrook, TXN259RHAlliance Aviation Group LLC · Wilmington, DEN25XPRd Airways LLC · Channelview, TXN260LFEthos Aviation LLC · Cleveland, OHN263SNBlue Skies Hawker LLC · Whitefish, MTN264RVHfa Specialty Acquisitions LLC · Boca Raton, FLN265HTmfb Transporation LLC · Orlando, FLN265JGShell Mountain Ranch LLC · Cranfills Gap, TXN266AJMoore Investment Fund LLC · Belmont, OHN268TSExpeditus Holdings LLC · Jacksonville, FLN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN275ERContinuum Aviation LLC · Oklahoma City, OKN277RSMaize & White Aviation LLC · Youngstown, OHN280BDLcg Enterprises LLC · Greenwich, CTN290GSBank Of Utah Trustee · Salt Lake City, UTN291BBattelle Memorial Institute · Columbus, OHN291FJNhs Management LLC · Tuscaloosa, ALN299PRMeregrass Inc · Dublin, TXN29BBattelle Memorial Institute · Columbus, OHN3007Empire Airlines Inc · Lebanon, MON303XX303 Aviation LLC · North Plains, ORN305BBBsc Landing LLC · Saint Louis, MON307DLNova Jets USA Corp · Orlando, FLN308DD225sbi LLC · Stuart, FLN30AXN27ax LLC · Tulsa, OKN310LJTvpx Ars Inc Trustee · North Salt Lake, UTN311BPWls Enterprise LLC · Portland, ORN311KBJet Plaid LLC · Nashville, TNN311RSKen Sale Resources Inc · Southlake, TXN312FUKenmore Crew Leasing Inc Trustee · Bellingham, WAN314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315RCRocklyn National LLC · Syracuse, NYN316CLCalco 316 LLC · Frisco, TXN317CQPrivate Fliers LLC · Wheaton, ILN31KHAery Aviation LLC · Wilmington, DEN31YAInternational Trading Energy Fuels LLC · Houston, TX
Back to AD 2017-20-01