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.
N2081SPlane Nonsense Inc · Middletown, DEN20830Atpce LLC · Wilmington, DEN2083FDetroit Public Schools Community District · Detroit, MIN20884Atpce LLC · Wilmington, DEN20887N20887 LLC · Augusta, GAN208CPChristiansen Aviation LLC · Wilmington, DEN208DGDelta Golf Aviation LLC · Pompton Plains, NJN208FT423 East Young LLC · Warrensburg, MON20910Atpce LLC · Wilmington, DEN20913Atpce LLC · Wilmington, DEN2093BTextron Aviation Inc · Wichita, KSN20945Georgia Forestry Commission · Macon, GAN20957Mustang Sally Aviation LLC · Camden, SCN2095JAviation Trust Co LLC Trustee · Oklahoma City, OKN2095SMrk Aviation LLC · Delray Beach, FLN2097GMountain Air Aviation LLC · Fruit Heights, UTN2097SLong Island Aviators LLC · Seaford, NYN2097TPatriot Aviation Inc · Greenville, DEN2098AAtp Aircraft 1 LLC · Wilmington, DEN2098CLynch Stephen J · Stamford, CTN2099DRollins Dale G · Covington, LAN2099NMicheal Charles E · Arlington, TXN2099YThompson And Harvey Holdings LLC · Orcutt, CAN209CSMat Air LLC · Bridgeport, TXN209JSCrystal Coast Training LLC · Kinston, NCN209KFf22 LLC · Scottsdale, AZN20ADDdd Partnership · Davis, CAN20APF & M Holdings LLC · Goshen, ALN20BQAb Prop Plane II LLC · Metairie, LAN20CNRegistration Pending · Bedford, PARegistration pendingN20DBLsn Air LLC · Morrison, CON20EPEpic Aviation Inc · New Smyrna Beach, FLN20KHN20kh LLC · Clewiston, FLN20KJOxford Flying Club Inc · Oxford, CTN20MVElizabeth City State University · Elizabeth City, NCN20SUOhio State University · Columbus, OHN21002Gr Aircraft LLC · Rancho Mirage, CAN2100SBietsch Aviation LLC · Dumfries, VAN21019Svetfur Aviation LLC · Camden, SCN2101GCarter James E · Thornville, OHN2101VWell Hung Metal LLC · Sulphur, LAN2101ZPico'S Plane LLC · Rockport, MEN21022Ameriflyers Of Texas Inc · Addison, TXN2102PZima Aviation LLC · Huntington Beach, CAN2103TIasco Flight Training Inc · Redding, CAN2103UCramm Raymond Eduard · Palmdale, CAN2104HGrenier Chad · Moorpark, CAN21056N21056 LLC · Wayne, PAN2105XAb Prop Plane II LLC · Metairie, LAN2107UFlight World Inc · San Juan, PR
Back to AD 2003-24-13