AD 2002-23-13
Registered aircraft · 3,462
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-23-13')
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-23-13')
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-23-13') 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-23-13') 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.
N914BRFitchs Flying Service LLC · Pearsall, TXN914DKCal-Ore Life Flight LLC · Brookings, ORN914FEFederal Express Corporation · Memphis, TNN914SHSanford Medical Center · Sioux Falls, SDN9152CLewis Flying & Maintenance Service Inc · Morse, LAFirst renewal noticeN9152RFlatland Aviation LLC · Indianola, MSN915CDN915cd LLC · Woodland, CAN915GDAir Charter Inc DBA · Culebra, PRN915JFFox James R · St Paul, MNN915MRGuardian Flight LLC · Lewisville, TXN916FEFederal Express Corporation · Memphis, TNN916GDAir Charter Inc DBA · Culebra, PRN916RTAasjng LLC · Holdrege, NEN917KRAction Aviation LLC · Idaho Falls, IDN917PCChester Haven LLC · Chester, SCN917TPAerial LLC · Kalispell, MTN917WAN917wa Corp Trustee · Wilmington, DEN917WGAmphib Air LLC · Fort Myers, FLN9184QMowata Farms LLC · Mamou, LAN9184UWest Hills Aviation Inc DBA · Huron, CAN9185FFarm Brothers Flyers A LLC · Grady, ARN9185GDodson International Parts Inc · Rantoul, KSN9187QLewis Flying & Maintenance Service Inc · Morse, LAN9187WAcadian Dusters LLC · Church Point, LAN9187ZEagle LLC · Sleepy Eye, MNN918BBAlco Aviation Services Consulting LLC · Taft, TNN918CACalifornia Highway Patrol · Sacramento, CAN918DDDiamond D Aviation LLC · Sulphur, LAN918FEFederal Express Corp · Memphis, TNN918JPAgricair Leasing LLC · Bancroft, WIN918MTIntegrity Aircraft Title Holdings LLC · Portland, ORN9190VT&T Highcountry Flying Service LLC · Saint Anthony, IDFirst renewal noticeN91918Thiel Air Care Inc · Chowchilla, CAN9192JAir Care Inc · Lamar, CON9193VMurtagh Flying Service Inc · Lexington, MSN9194PLeading Edge Aero LLC · Southampton, NJN91959Aslesen Leasin LLC · Halstad, MNN9195XRba LLC · Kimberly, IDN9196CWoodley Aerial Leasing LLC · Walnut, ILN9196ZOscar Aviation LLC · Livonia, LAN9197DT-C Aerial LLC · Littlefield, TXN919BGFreebird Aviation LLC · Monahans, TXN919GDAir Charter Inc DBA · Culebra, PRN919REIvy Brothers Aviation LLC · Kilgore, TXN91CLAircraft Structures International Corp · Enid, OKN91CTClemson University · Clemson, SCN91CVTwin P Aviation LLC · Fort Worth, TXN91SDynamic Avlease Inc · Bridgewater, VAN91WFLouisiana Department Of Wildlife And Fisheries · Baton Rouge, LAN920FEFederal Express Corp · Memphis, TN
Back to AD 2002-23-13