AD 2010-26-05 R1
Registered aircraft · 1,068
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:2010-26-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-26-05-R1')
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:2010-26-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-26-05-R1') 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.
N248LXHaus Of Suss LLC · Dallas, TXN250DLHoward Flight Services LLC · Lascassas, TNN250JCProspectpb LLC · Wilmington, DEN250LPMetta 2000 LLC · Dorado, PRN250WJEastview Av Partners I LLC · Kings Point, NYN2511BDealer Equipment Leasing LLC · Miami, FLN252PJFalcon 900ex Msn 52 LLC · New Castle, DEN254FJAnthem Ventures LLC · Austin, TXN256RCVulcan Materials Company · Vestavia, ALN256VGitsis Nick Trustee · MakatiN25KZB & T Aviation USA LLC · Lakeland, FLN25MXAce Parts LLC · Santa Fe Springs, CAN25STLewis Garry L · Livingston, LAN25VRN25vr LLC · Portland, ORN261CHSeecon Builders Inc · Concord, CAN264CDf 254 Holdings LLC · Wilmington, DEN264RVHfa Specialty Acquisitions LLC · Boca Raton, FLN264VFlight 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, FLN270MFBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN272DNDel Mar College · Corpus Christi, TXN272FCBest 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, FLN280BDLcg Enterprises LLC · Greenwich, CTN281QSSale Reported · Wilmington, DESale reportedN281SCFreedom Rising LLC · Corona, CAN2828Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN282TRed Star Aero Holdings LLC · Lewes, DEN283SADodson International Parts Inc · Rantoul, KSN285KKHaystack 204 LLC · Portland, ORN286CXPinnacle Assurance LLC · Tampa, FLN286MJHc Logistics LLC · Chicago, ILN288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28DCMbogo Energy LLC · Boerne, TXN291BBattelle Memorial Institute · Columbus, OHN291MJTequila Mockingbird LLC · New York, NY
Back to AD 2010-26-05 R1