AD 2003-24-13
Registered aircraft · 7,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:2003-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:2003-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:2003-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:2003-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.
N327ADGundry Adam · Superior, WIN327GHTextron Aviation Inc · Wichita, KSN327MTHayden LLC · Tiburon, CAN327SPAmeriflyers Of Texas Inc · Addison, TXN327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CAN3288Mewmew Investment II LLC · Palo Alto, CAN328CACivil Air Patrol · Maxwell Afb, ALN328FAAb Prop Plane II LLC · Metairie, LAN328MEFlying Start Aero Services LLC · Reno, NVN328TASuburban Air Corp · Castro Valley, CAN328TMMathews Thomas J · New Castle, INN329CPCivil Air Patrol · Maxwell Afb, ALN329CSOvercast 329 LLC · Jonesboro, ARN329KBMagee Brad D · Durango, CON329MABarr Air Patrol LLC · Mesquite, TXN329MECentral Iowa Aviation LLC · Ankeny, IAN329WPPhillips J Weston · West Jefferson, NCN32HSFarm Boy Aviation LLC · Boynton Beach, FLN32LPBartlett Paul H · Nebo, NCN32LTLt Leasing LLC · Saint Petersburg, FLN32MTHeading 406 LLC · Kalispell, MTN32PSDepartment Of The Interior · Boise, IDN330JDGreen Erik M · Mastic Beach, NYN330JEWings Over Texas Holdings LLC · Denton, TXN330MEUnique Educational Experiences · Signal Hill, CAN330PMPractical Education LLC · New York, NYN3314SN3314s LLC · Oklahoma City, OKN331CHCh Wings LLC · Arvada, CON331CPCivil Air Patrol · Montgomery, ALN331GWFieldcrest Air LLC · Latrobe, PAN331JKKenzy 2020 LLC · Aurora, ORN331MEHarrison Matthew T · Naponee, NEN331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKN331RPRaritan Valley Flying School · Princeton, NJN332CPCivil Air Patrol · Maxwell Afb, ALN332MCClover Park Technical College · Lakewood, WAN332SCSilver Creek Aviation Services · Fort Worth, TXN332SPMh Aviation LLC · Foster City, CAN3338VAero-Tech Services Inc · Lititz, PAN333FRHofstetter Seth · Jacksonville, ORN333JEJs Aviation Inc · Valparaiso, INN333PFDennis Bruce · Hesperus, CON333TCKaty Partnership Leasing LLC · Watertown, SDN333TSAerostar Management Services LLC · Kissimmee, FLN334SASchaumburg Flying Club Nfp · Palatine, ILN334SPSierra Pop Air LLC · Wilmington, DEN334WDSouthwest Aviation Enterprises · Haslet, TXN335JWN335jw LLC · Hilton Head Island, SCN335MCLewis University · Romeoville, ILN335MECentral Iowa Aviation LLC · Ankeny, IA
Back to AD 2003-24-13