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.
N294CSState Of Wisconsin Department Of Administration · Madison, WIN294EMClover Park Technical College · Lakewood, WAN294MAWalker Leasing LLC · Browerville, MNN294PEPhoenix East Aviation LLC · Daytona Beach, FLN294PLAerospring Leasing LLC DBA · Wasilla, AKN294RWAb Prop Plane II LLC · Metairie, LAN294SPMazurek Harold Wayne · Sidney, TXN294TFTextron Aviation Inc · Wichita, KSN295CSLarsen Levitation LLC · Wasilla, AKN295LPWildridge Aviation LLC · Layton, UTN295MEWings Air Charter LLC · Wisconsin Rapids, WIN295PEPhoenix East Aviation LLC · Daytona Beach, FLN295PLAerospring Leasing LLC DBA · Wasilla, AKN295TFTextron Aviation Inc · Wichita, KSN296CPCivil Air Patrol · Maxwell Afb, ALN296CS1928 LLC · Salmon, IDN296DEDouble T Flyers LLC · Fort Worth, TXN296FSD7 Roofing LLC · New Baden, ILN296MEJwl Aviation LLC · San Carlos, CAN296NWNorthwestern Michigan College · Traverse City, MIN296PBChurch Aviation LLC · Christmas Valley, ORN296PEPhoenix East Aviation LLC · Daytona Beach, FLN296PLAerospring Leasing LLC · Wasilla, AKN297BBoard Of Trustees Of Southern Illinois University · Carbondale, ILN297BCUnderwood David · Sarasota, FLFirst renewal noticeN297CMHeritage Aviation Management Ltd · Conroe, TXN297CPChristiansen Aviation LLC · Wilmington, DEN297MET L B Inc · Howell, NJN297PEPhoenix East Aviation LLC · Daytona, FLN297PLAerospring Leasing LLC · Wasilla, AKN297TCMoody Bible Institute Of Chicago · Spokane Valley, WAN298CPCivil Air Patrol · Maxwell Afb, ALN298DBButler John P · Hazelhurst, WIN298MCJ C B Aircraft Sales And Leasing · Princeton, NJN298MEVermont Flight Academy Inc · South Burlington, VTN298PEPhoenix East Aviation LLC · Daytona Beach, FLN298PLTextron Aviation Inc · Wichita, KSN298PN206 Cat Air LLC · Salem, ORN298SCCharlie Aviation LLC · Oregon City, ORN299CSTextron Aviation Inc · Wichita, KSN299KCKings County Sheriff'S Office · Hanford, CAN299KJN299kj LLC · Auburn, WAN299MCN299mc LLC · Auburn, WAN299PLTextron Aviation Inc · Wichita, KSN299SPNorth Dakota Highway Patrol · Bismarck, NDN29AFDale Michael · Murrieta, CAN29AJWest Alabama Aviation Leasing LLC · Tuscaloosa, ALN29HTTrede 2023 LLC · Aurora, ORN29NPCrown Air LLC · Bend, ORN2GTT20608770 Inc Trustee · Wilmington, DE
Back to AD 2003-24-13