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.
N389CPCivil Air Patrol · Maxwell Afb, ALN389HMHausmann Aero LLC · Grand Forks, NDN389MEWhitewillow LLC · Minooka, ILN389TDParagon Air Group · Fort Worth, TXN38ALAirloc LLC · Atlanta, GAN38BGCary Aviation LLC · Myrtle Beach, SCN38PCLake Day Ventures LLC · Missoula, MTN38PDRichmond Pilots Corp · Linden, NJN38RAAb Prop Plane II LLC · Metairie, LAN38SBAb Prop Plane II LLC · Metairie, LAN38USUnited States Aviation Underwriters Inc · New York, NYN38WRCds Worldwide Consultants Pllc · Birmingham, MIN390MEMccabe Eugene · Fremont, CAN391MState Of Montana Dept Of Natural Resources · Helena, MTN391SPN391sp LLC A Series Of Aero Lease LLC · San Antonio, TXN392CVBreen James J · Alpharetta, GAN392EREmbry-Riddle Aeronautical University · Daytona Beach, FLN392MEFrees Media Inc · Livingston, NJN393CA2050 Services LLC · Burlington, WIN393ESLanier Equipment Leasing LLC · Gainesville, GAN393SPCirrus Aviation · Sarasota, FLN394CACivil Air Patrol · Maxwell Afb, ALN394CVBas Part Sales LLC · Greeley, CON394SPEdb Air Inc · Wilsonville, ORN395CVCivil Air Patrol · Maxwell Afb, ALN395MEYqa Capital Management LLC · Murfreesboro, TNN395SPTexas State Technical College · Waco, TXN396CVCivil Air Patrol · Maxwell Afb, ALN396MCJf Aviation LLC · Minot, NDN396SPFritz Daniel G · Lodi, CAN396TAMonterey Bay Aviation Inc · Watsonville, CAFirst renewal noticeN397CACivil Air Patrol · Maxwell Afb, ALN397CPCivil Air Patrol · Maxwell Afb, ALN397CVCivil Air Patrol · Maxwell Afb, ALN397ESN397es Holding LLC · Palm City, FLN397MELima Air LLC · Cape Coral, FLN397MWMccann Shawn Edward · Newton, NJN397TCBravo & Bravo LLC · Greenville, MEN398CPCivil Air Patrol · Maxwell Afb, ALN398CVCivil Air Patrol · Maxwell Afb, ALN398ESChristiansen Aviation LLC · Wilmington, DEN398MEDesalvo Dennis · St Louis, MON399AAAoa Kissimmee Inc · Kissimmee, FLN399CPCivil Air Patrol · Maxwell Afb, ALN399CVCivil Air Patrol · Maxwell Afb, ALN399ESBray Aviation LLC · Calera, OKN399MESound Sleep Clinic Pllc · Bainbridge Island, WAN399TBg Flight Group LLC · Bowling Green, KYN39BBHammonds Willard H II · Corpus Christi, TXN39PDBechard Barry C · Mount Joy, PA
Back to AD 2003-24-13