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.
N246CPCivil Air Patrol · Maxwell Afb, ALN246MEWyoming Seaplanes LLC · Alpine, WYN246NSilver Creek Aviation Services · Fort Worth, TXN246SECannavair Inc · Seattle, WAN246SFAb Prop Plane I LLC · Metairie, LAN2470BAlpha International Aircraft Inc · Lewes, DEN2470FMeridian Aviation LLC · Lincolnton, NCN2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedN2470PFisher Air LLC · Cardington, OHN2471DWestern Edge Aviation LLC · Dickinson, NDN2472UMustang Sally Aviation LLC · Camden, SCN24738H2link Co · Lewes, DEN2473GFly For Fun Aircraft LLC · Baltimore, MDN2473ZGulf Coast Aviation LLC · New Orleans, LAN24747Peachey Farms LLC · Decatur, IAN24748Delta State University · Cleveland, MSN2474CArchitectural Industrial Rentals LLC · Wilmington, DEN2474NWestbank Fishing LLC · Kiln, MSN2474VRbj Ranch LLC · Elroy, WIN2474YLogan Air Services LLC · Logan, UTN24756Wings Over Texas Holdings LLC · Denton, TXN2475LDeralex Airways LLC · Miami, FLN2476ESkyspot Advertising LLC · Lakeland, FLN2476JCrosshares Aircraft Holdings LLC · Plymouth, INN2476XPs N2476x LLC · Green Bay, WIN2476YAmerican Aviation Inc · Brooksville, FLN2477FChristiansen Aviation LLC · Wilmington, DEN2477JAviation Training LLC · Wilmington, DEN2477XLecce Aviation LLC · Williamsport, PAN24780San Diego Flight Training International Inc · San Diego, CAN24783Elite Approach LLC · Chesterfield, MON24787W Tech Consulting Inc · Wilmington, DEN2478AEnnair LLC · Kalispell, MTN2478DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2479BPac 2 LLC · Clinton, IAN2479MSt Thomas Jet Center Flying Club LLC · Lewes, DEN247AUPeregrine Howard Partners II Lp · New Orleans, LAN247FMansfield Heliflight Inc · Milton, VTN247SARoss Branta Enterprises · Boise, IDN248JWN248jw LLC · Sammamish, WAN248RAReynolds Darryl G · Wills Point, TXN248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeN248RRWalter Air Co LLC · Oakdale, CAN248SFEl Prop Plane I LLC · Metairie, LAN249BKWaggoner Carter · Calera, ALN249FMValiair Limited Co Trustee · Casper, WYN249FSAdvanced Charter & Instruction LLC · Costa Mesa, CAN249JSCrystal Coast Training LLC · Kinston, NCN249KFf22 LLC · Scottsdale, AZN249TARkl Consulting LLC · Keizer, OR
Back to AD 2003-24-13