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.
N356DHCompass Rose Aviation LLC · Derby, KSN356ESPremier Flight Center LLC · Hartford, CTN356MEGlass Cockpit Aviation-Sunvalley LLC · Hailey, IDN356SFSheehan Aviation Family Enterprises LLC · Boise, IDN357BCChristopher Brian A · Panama City Beach, FLN357CPCivil Air Patrol · Maxwell Afb, ALN357DRImsar LLC · Springville, UTN357DWFlight Training Aircraft LLC · Wilmington, DEN357ESReeno Aviation LLC · Lewisville, NCN357HMH & M Aviation LLC · Madison, MSN357HRMartin Hein Ranch Co · Visalia, CAN357KFAirmart Inc · Lexington, KYN357MEMichigan Dept Of Natural Resources · Roscommon, MIN357MGAircraft Guaranty Corp Trustee · Oklahoma City, OKN357ZCowden Flying Services Inc · Ft Worth, TXN35812Cielo Vista Inc · Milford, DEN358CBHurn Farm Enterprises LLC · Grand Beach, MIN358CPCivil Air Patrol · Maxwell Afb, ALN358ESSoutheastern Veterinary Relief Services LLC · Orange Park, FLN358GMTextron Aviation Inc · Wichita, KSN358MERibelin Holdings LLC · Yacolt, WAN358TWTubreaux Aviation Services LLC · Shreveport, LAN359CPCivil Air Patrol · Maxwell Afb, ALN359SPSilverhawk Aviation Academy Oregon LLC · Ontario, ORN359TWDouble Bogey Aviation LLC · Midland, TXN35VAN27ax LLC · Tulsa, OKN35ZQZq Navigation LLC · Bellingham, WAN360CPCivil Air Patrol · Maxwell Afb, ALN360CWCentral Washington University · Ellensburg, WAN360ECdw Flyers LLC · Kinnelon, NJN360ESEdb Air Inc · Wilsonville, ORN360MEB L T 360 Aviation LLC · Dalhart, TXN360SPN360sp LLC · Palm City, FLN361CPBarr Air Patrol LLC · Mesquite, TXN361DBLcb Leasing · Manassas, VAFirst renewal noticeN361ESGrady Paul D · Reno, NVN361GAGlidewell Aviation Inc · Parkland, FLN361LRegistered aircraftN361LULewis University · Romeoville, ILN361MState Of Montana Dept Of Natural Resources · Helena, MTN361SPTextron Aviation Inc · Wichita, KSN361TEBald Knoll Aviation LLC · Cliff, NMN361TKReckless Air LLC · Greenback, TNN362ESIasco Flight Training Inc · Redding, CAN362KTOverstreet Investments Inc · Boonville, MON362LULewis University · Romeoville, ILN362MState Of Montana Dept Of Natural Resources · Helena, MTN362MEDesmond James M · Oceanside, CAN362QRegistered aircraftN362SPEastern Cincinnati Aviation Inc · Batavia, OH
Back to AD 2003-24-13