AD 2002-13-07
Registered aircraft · 824
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-13-07')
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-13-07')
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-13-07') 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-13-07') 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.
N247GKJoseph Equities LLC · Schiller Park, ILN247WDNgl Aviation Den LLC · Denver, CON248BTDelsey LLC · Newport Beach, CAN248LXHaus 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, FLN25STLewis Garry L · Livingston, LAN25VRN25vr 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, FLN272DNDel 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, FLN281QSSale 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, ILN291MJTequila 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 aircraft
Back to AD 2002-13-07