AD 2002-01-23
Registered aircraft · 329
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:2002-01-23')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-23')
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:2002-01-23') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-23') 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.
N445VLChill Aviation LLC · Saint Petersburg, FLN445VRRonco-Wales LLC · Ponte Vedra, FLN448SCHawk Eagle LLC · Moon Township, PAN449TMJersey Aviation LLC · Stamford, CTN44MMMike Moser Inc · Wilmington, DEN450TMWheels Up Partners LLC · New York, NYN452TMWheels Up Partners LLC · New York, NYN453TMWheels Up Partners LLC · New York, NYN458SFAcme Leasing III LLC · Nashville, TNN45RKTeam Aero LLC · Shawnee, KSN460TMJersey Aviation LLC · Stamford, CTN461SJFlight Options LLC · Cleveland, OHN462SJFlight Options LLC · Cleveland, OHN463SJFlight Options LLC · Cleveland, OHN472EMCarver Air LLC · Albany, NYN472GJAlliance Aviation Group LLC · Wilmington, DEN473FLNam Jet LLC · Great Neck, NYN475TCMtj Aviation LLC · Mooresville, NCN475XPL And P Air 1 LLC · Lees Summit, MON476BJDodson International Parts Inc · Rantoul, KSN477TMAlliance Aviation Group LLC · Wilmington, DEN478DRDrct-III LLC · Maple Grove, MNN479DRL And P Air LLC · Lees Summit, MON481MMThree Ninety LLC · Topeka, KSN482GSCatawba Management Corp · Middleburg, VAN482RKHeisler Aviation LLC · Jacksonville, FLN482TMJersey Aviation LLC · Stamford, CTN484TPSky Aviation Holdings LLC · Pompano Beach, FLN485CTWheels Up Partners LLC · New York, NYN488BVcv Texas LLC · Boerne, TXN488DBAircraft Logistics Group LLC · Oklahoma City, OKN489AMAirmed International LLC · Birmingham, ALN489TMJersey Aviation LLC · Stamford, CTN48HWN48hw Leasing LLC · Wichita, KSN490AMAirmed International LLC · Birmingham, ALN490FLFlight Options LLC · Cleveland, OHN491TMJersey Aviation LLC · Stamford, CTN492FTAli Awad Law P C · Marietta, GAN492TMAlliance Aviation Group LLC · Wilmington, DEN495CTJet Life Company LLC · Laredo, TXN496TMSdl Gulfstream LLC · Paradise Valley, AZN497XPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4988VSintra Property Management Inc · Palm City, FLN498SBNovember Zulu Enterprises LLC · Liberal, KSN49AS205as Holdings LLC · Newark, DEN500PMPsm Holdings Inc · Orlando, FLN501BWRomero Leasing Inc · Stuttgart, ARN501XPAlg Transportation Inc · Kansas City, MON502CACentex Aero LLC Trustee · San Antonio, TXN502TCTvpx Ars Inc Trustee · North Salt Lake, UT
Back to AD 2002-01-23