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.
N426ESWeaver Corey E · Saline, MIN426JGAero Flight School No7 LLC · Lincoln Park, NJN426LPAir Mates Flying Club Inc · Northfield, NJN426PWElectron International Aviation LLC · Phoenix, AZN426RBChristiansen Aviation LLC · Wilmington, DEN4274RCatset Funding LLC · Coral Gables, FLN427AMState Of Oregon · Salem, ORN427APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN427CPCivil Air Patrol Inc · Maxwell Afb, ALN427CRAb Prop Plane II LLC · Metairie, LAN427CSVan Bortel Aircraft Inc · Arlington, TXN427EPChristiansen Aviation LLC · Wilmington, DEN427JDMule Air LLC · San Antonio, TXN427KRDean Michael D · Montrose, CAN428CPCivil Air Patrol Inc · Maxwell Afb, ALN428DWArizona Cloudbusters Inc · Mesa, AZN428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN428FFDhs Operations LLC · Wilmington, DEN428LBMam Aviation LLC · New York, NYN428MTNby Productions · Manassas, VAN428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLN429CPCivil Air Patrol Inc · Maxwell Afb, ALN429EPBbm Air LLC · Macon, GAFirst renewal noticeN429ESBarbers Point Flight School LLC · Kapolei, HIN429FFDhs Operations LLC · Wilmington, DEN429JPHnb Aviation LLC · Forestburg, TXN429LChristiansen Aviation LLC · Wilmington, DEN42LLGayden Marshall G · Wilmington, NCN42RLChristiansen Aviation LLC · Wilmington, DEN43043Environmental Safety & Health Consulting Svcs Inc · Houma, LAN430CACivil Air Patrol · Maxwell Afb, ALN430CPCivil Air Patrol · Maxwell Afb, ALN430DMNwa Leasing Group LLC · Springdale, ARN430EPFly La Wings LLC · Glendale, CAN430EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN430MBDbbsx LLC · Kalispell, MTN430SDMedary Aviation LLC · Brookings, SDN430UCheyenne LLC · West Mifflin, PAN431AFBuha Holdings LLC · Paris, TXN431CPCivil Air Patrol · Maxwell Afb, ALN431CRAb Prop Plane II LLC · Metairie, LAN431FPSky West Aviation Inc Trustee · Albuquerque, NMN431FRN3812q LLC · San Diego, CAN432AAAoa Kissimmee Inc · Kissimmee, FLN432BPLaporte Enterprises LLC · Midland, TXN432CACivil Air Patrol · Maxwell Afb, ALN432EAVanderloop Equipment Inc · Brillion, WIN432ERUnicorn Wings LLC · Cary, ILN432FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN432MTFoundation Holdings LLC · Jonesboro, AR
Back to AD 2003-24-13