AD 2004-01-05
Registered aircraft · 870
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:2004-01-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-01-05')
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:2004-01-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-01-05') 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.
N252PJFalcon 900ex Msn 52 LLC · New Castle, DEN254FJAnthem Ventures LLC · Austin, TXN256RCVulcan Materials Company · Vestavia, ALN25KZB & T Aviation USA LLC · Lakeland, FLN25MXAce Parts LLC · Santa Fe Springs, CAN25VRN25vr LLC · Portland, ORN261CHSeecon Builders Inc · Concord, CAN264CDf 254 Holdings LLC · Wilmington, DEN264VFlight Basic Services LLC · Saint Paul, MNN2652Columbia Bank · Lake Oswego, ORN265HTmfb Transporation LLC · Orlando, FLN269PHPruitt Tran II LLC · Norcross, GAN26NJAlliance Aviation Group LLC · Wilmington, DEN26SMTricor Aviation LLC · Winter Park, FLN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN272FCBest Aviation Inc · Baldwin, GAN273LXFrist Aviation LLC · Nashville, TNN273SWRegistered aircraftN274SGFree Bird Flight Ops LLC · Newport Beach, CAN275SWRegistered aircraftN277XXBank Of Utah Trustee · Salt Lake City, UTN278GHTdsair LLC · Fishers, INN278RFGlenbrook III LLC · San Jose, CAN279SWRegistered aircraftN27AFAir4 Aviation LLC · Houston, TXN27FJAviation Resource Group Inc · Ft Lauderdale, FLN281QSSale Reported · Wilmington, DESale reportedN281SCFreedom Rising LLC · Corona, CAN2828Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN285KKHaystack 204 LLC · Portland, ORN286CXPinnacle Assurance LLC · Tampa, FLN286MJHc Logistics LLC · Chicago, ILN288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28DCMbogo Energy LLC · Boerne, TXN291MJTequila Mockingbird LLC · New York, NYN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTN2NLCenturion Investments Inc · Chesterfield, MON301AFAir4 Aviation LLC · Houston, TXN301MTRegistered aircraftN303CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303TFNtc Aviation LLC · Greenwich, CTN304KSonic Automotive Inc · Charlotte, NCN306BHSdy Leasing LLC · Waterford, MIN306SHN306sh LLC · Chicago, ILN307MDN307md LLC · Barrington, RIN30HQLearjet Inc · Wichita, KSN310ZAZair Force One LLC · Mendenhall, MSN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraft
Back to AD 2004-01-05