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.
N2PSUnited States Department Of The Interior · Boise, IDN3005YGreen Acres Aviation LLC · Berryville, ARN300EPVan Anda Aviation LLC · Apopka, FLN300KXAtp Aircraft 2 LLC · Wilmington, DEN300WFAmoth Kurt J Trustee · White Salmon, WAN301CFSunrise Aviation Inc · Ormond Beach, FLN302AFState Of Louisiana · Baton Rouge, LAN302CFEastern Kentucky University · Richmond, KYN302MPKqm Aviation · Bristow, VAN302TXCareer Track 2 LLC · Wilmington, DEN302WDAmado'S Holdings LLC · Rice, MNN3033LDaniel Gary · Fallston, MDN303EHNavigation Leasing LLC · Keizer, ORN303HBFly The Coop LLC · Newton, KSN303KATjs3 Aviation LLC · Wilmington, DEN303RHNavigation Leasing LLC · Kaizer, ORN303SFSnohomish Flying Service Inc · Snohomish, WAN303STVolar Vii LLC · Edmond, OKN3040MAustin 206 Aviation LLC · Americus, GAN304CACivil Air Patrol · Maxwell Afb, ALN304CGVan Bortel Aircraft Inc · Arlington, TXN304CPCivil Air Patrol · Maxwell Afb, ALN305CPCivil Air Patrol · Maxwell Afb, ALN305DKWashington State Patrol · Olympia, WAN305FGRidgeline Assets LLC · Wilmington, DEN305JGAbeona-Adeona Aviation LLC · Wilmington, DEN305JRHarrison Aviation LLC · Salem, ORN305MTMtc Air LLC · Homestead, FLN305RCWashington State Patrol · Olympia, WAN305RSElite Approach LLC · Chesterfield, MON305TXCareer Track 2 LLC · Wilmington, DEN305WTToro Procurement LLC · San Angelo, TXN3064CN3064c LLC · San Tan Valley, AZN306CACivil Air Patrol · Maxwell Afb, ALN306CSSecurity Alert Aviation LLC · Gilroy, CAN306DPHer Airway LLC · Boca Grande, FLN306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILN306PPSl Aviation LLC · Seattle, WAN307BZSummit Aviation Inc · Belgrade, MTN307CSDetwiler Jeffrey D · Lancaster, PAN307RJGv Air Inc · Medford, ORN308AROverstreet Investments Inc · Boonville, MON308CLRodoni William · Santa Cruz, CAN308CPCivil Air Patrol · Maxwell Afb, ALN308DMD&M Aircraft Co Inc · Thonotosassa, FLN308NRState Of Wisconsin · Madison, WIN308SPAmeriflyers Of Texas Inc · Addison, TXN309BRValdosta Flying Service Inc · Valdosta, GAN309DKNby Productions · Bristow, VAN309GMScroggins Aero LLC · Cabot, AR
Back to AD 2003-24-13