AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-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:2007-24-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:2007-24-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:2007-24-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.
N724CMParker Air LLC · Mobile, ALN724DEAero Air LLC · Hillsboro, ORN724SRFlyme2 LLC · Leesburg, VAN725AAMoon Flying LLC · Centreville, VAN725CDRussell Wade M Jr · Sandy Springs, GAN725CPHolmberg Bryan J · Parkland, FLN725EBHickory Falls LLC · Naperville, ILN725LKDuluth Aviators LLC · Duluth, MNN725WTJ&E Adventures LLC · Conroe, TXN726CCStk Flight LLC · New Palestine, INN726KRE&E LLC · Johnston, IAN726PBN411b LLC · Griffin, GAN726PDBuchanan Thomas Steven · Hilton Head Island, SCN726PMAlpine View LLC · Williston, NDN726ZMission Park Air LLC · Marion, IAN727CDN727cd LLC · Clearwater, FLN727HGShirin Aviation LLC · Los Angeles, CAN727JKSky 21 LLC · Lexington, NCN727PWSteven Bennett Trustee · Boise, IDN727SPinnacle Aviation Services LLC · Key Largo, FLN727SLRegistered aircraftN727SRMid-Way Regional 2023 LLC · Columbia Falls, MTN728BJBarefoot Boats LLC · Greensboro, GAN728SRSouthside Tire Co Inc · Antigo, WIN729AJEdwards 729aj LLC · Dublin, OHN729CDOmega Skyways LLC · North Bethesda, MDN729JRJbj Air Services LLC · Virginia Beach, VAN729JSJackson Christopher F · Vancouver, WAN729SASierra Alpha Leasing LLC · Naples, FLFirst renewal noticeN72BKUpper Airways LLC · Kalispell, MTN72DVStirling Motors LLC · Kalispell, MTN72ETCirrwest Ltd · Grand Junction, CON72GGHall Joel · Nashville, TNN72JESkyward LLC · Fort Smith, ARN72LLKusy LLC · New Rochelle, NYN72MJValiair Lc Trustee · Casper, WYN730CN730c LLC · Merrimack, NHN730CDCirrus Associates LLC · Colorado Springs, CON7311KChunga Air LLC · Orange Park, FLN731APEastway Properties LLC · Moxee, WAN731ATMark L Carman · Aiken, SCN731CDOwen Brian F · Tulsa, OKN731JHGcl Juliet Hotel LLC · Winter Springs, FLN731PPPoli Poli Inc · Sausalito, CAN731VCCuster Joseph A Jr · League City, TXN731WF29 Aviation LLC · Granite Falls, MNN732ABJohn L Dolan Consulting LLC · Vienna, VAN732CDK9 Aviation LLC · Tyler, TXN732SGSorrydog Aviation LLC · Bushnell, FLN733CDHerron Kevin · Checotah, OKFirst renewal notice
Back to AD 2007-24-13