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.
N433EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN433FRKtoa Rentals LLC · Torrance, CAN433LPJl Fuertes LLC · Miami, FLN433SPAspire Aviation LLC · Farmingdale, NYN433TAM7 LLC · Idaho Falls, IDN434AHSkywest Leasing Inc · St George, UTN434CPCivil Air Patrol · Maxwell Afb, ALN434CSBaldwin Scott Ryan · Kamas, UTN434EPNashville Flight School LLC · Nashville, TNN434SPLlp Leasing Group LLC · Lewes, DEN435CAWingsleasing LLC · Wichita, KSN435CKHycas LLC · Bountiful, UTN435SPBoeing Employees Flying Association · Renton, WAN435TAPanther Med LLC · Derby, KSN436AGSkywest Leasing Inc · St George, UTN436CAWingsleasing LLC · Wichita, KSN436CSBulovic Mark · Savannah, GAN436PWRegistration Pending · Walnut, CARegistration pendingN436SPHillsboro Aero Academy LLC · Hillsboro, ORN436THSnohomish Flying Service Inc · Snohomish, WAN437CPCivil Air Patrol · Maxwell Afb, ALN437EPAb Prop Plane II LLC · Metairie, LAN437FAWhiskey Charlie Aero LLC · Poway, CAN437HMNby Productions · Bristow, VAN437PSWest Michigan Aviation Academy · Grand Rapids, MIN437SPN437sp LLC · Manassas, VAN438CPCivil Air Patrol · Maxwell Afb, ALN438ERMorey Airplane Company Inc · Middleton, WIN438SATwopro Energy Services LLC · Odessa, TXN438SCAlpha Charlie Aviation LLC · Oregon City, ORN4396DBass Aviation LLC · Lewes, DEN439CPCivil Air Patrol · Maxwell Afb, ALN439CSMarionneaux Law Firm LLC · Baton Rouge, LAN439ERMorey Airplane Co Inc · Middleton, WIN439ESH R Management LLC · Bay Saint Louis, MSN439LPTps Aviation LLC · Los Angeles, CAN43MZN9fx LLC · Columbus, MTN43RDMerrell Robert W Trustee · Boulder City, NVN43TRMeichelle Enterprises Inc · Santa Barbara, CAN43VBGv Air Inc · Medford, ORN43VRMountain Ridge Aviation LLC · Millersburg, PAN440ERChristiansen Aviation LLC · Wilmington, DEN440FAA-Cent Aviation Inc · Jacksonville, FLN440MGSkyclub Aviation LLC · Wilson, NCN440SPHoletz Consulting Inc · Minneapolis, MNN441CAAtp Aircraft 4 LLC · Wilmington, DEN441CPCivil Air Patrol · Maxwell Afb, ALN441ERVeve Jesus Vila · Mayaguez, PRN441HPMotorcarlease USA Inc · Miami Beach, FLN441QFChristiansen Aviation LLC · Wilmington, DE
Back to AD 2003-24-13