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.
N266BBJk Air LLC · Duncan, OKN266LARaintree Aviation LLC · Mesa, AZN266MEGershman Randy · Marshfield, WIN266SPTfs Air LLC · Loveland, CON266TATextron Aviation Inc · Wichita, KSN2672XBird Nest Aviation LLC · Sheldon, IAN267ABConcrete Experts LLC · Colorado Springs, CON267FGRidgeline Assets LLC · Wilmington, DEN267HPFlorida Highway Patrol · Tampa, FLN267JMMathews Development Co · Santa Rosa Beach, FLN267MCKitchen Blaine III · Rochester, MAN267MECape Aero LLC · Cape Girardeau, MON267RHPxw Services · Bristow, VAN2680XN2680x LLC · Mountain Home, ARN2682CInternational Air Services Inc Trustee · Carson City, NVN2687LA R Preston Holdings LLC · Ontario, NYN268CPCivil Air Patrol · Maxwell Afb, ALN268CSInternational Air Services Inc Trustee · Carson City, NVN268CTCoast Flight Training And Management Inc · San Diego, CAN268EPEpic Aviation Inc · Denison, TXN268FMRunamuck LLC · New Orleans, LAN268HPFlorida Highway Patrol · Tampa, FLN268MERegistered aircraftN268TZHague Robert A · Rogers, ARN268ZMewmew Investment II LLC · Palo Alto, CAN2698XHall Clinton Arthur Jr · Klamath Falls, ORN269DDAircraft Solutions Group LLC · Englewood, CON269EPEpic Aviation Inc · Denison, TXN269FGMustang Sally Aviation LLC · Camden, SCN269MEGeorge'S Aviation Services · Honolulu, HIN269SFlightco Inc · Swainsboro, GAN269SAAlthof Equipment Management LLC · Jupiter, FLN269SHDan Julian LLC · Woodway, TXN26AAMustang Sally Aviation LLC · Camden, SCN26BMRegistered aircraftN26BQAb Prop Plane II LLC · Metairie, LAN26KMPerformance Aviation Solutions LLC · Meridian, IDN26LPAb Prop Plane II LLC · Metairie, LAN26NZBank Of Utah Trustee · Salt Lake City, UTN26VRReed Edward · Marcellus, MIN26WEGrand Aviation LLC · Asbury, NJN270CACivil Air Patrol · Maxwell Afb, ALN270CPCivil Air Patrol · Maxwell Afb, ALN270DMMarbry Holdings LLC · Naples, FLN270FASchoettelkotte Christopher B · Friendswood, TXN270JARegistered aircraftN270MEMm Aviation LLC · Casa Grande, AZN270SPSan Pedro Aviation LLC · San Antonio, TXN270UOhio University · Albany, OHN2711RBoeing Employees Flying Association Inc · Renton, WA
Back to AD 2003-24-13