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.
N60155Jls Aviation LLC · Sarasota, FLN60166Gabriel/Jordan Holdings Gp Inc · Henderson, TXN6016BTnj Adventures LLC · Kalispell, MTN6016VTiseo Paul J · Chester, CTN6017LAviation Training LLC · Wilmington, DEN6017NGood Dog Leasing LLC · Vienna, VAN6018KChristiansen Aviation LLC · Wilmington, DEN6018ZWarner Aviation Co · Council Bluffs, IAN6019VChristiansen Aviation LLC · Wilmington, DEN6019XRuegg Charles E · Belfast, MEN601LSM&G Aircraft Management LLC · Englewood, CON6020F7l Air LLC · Franklin, TXN6020KDuont LLC · Portola Valley, CAN6020ZTisdale Enterprises LLC · Pensacola, FLN6021FB R S Leasing Inc · Wilmington, DEN6021KRegistration Pending · Grand Forks, NDRegistration pendingN6021MPark Rapids Avionics Inc · Park Rapids, MNN6022JPavise LLC · Midland, TXN6022NStrong Brothers Aviation Inc · Leesburg, FLN6023FAviation Systems & Service LLC · Mounds, OKN6023SChristiansen Aviation LLC · Wilmington, DEN6023VChristiansen Aviation LLC · Wilmington, DEN6024EDhs Operations LLC · Wilmington, DEN6024TDouglass Bruce · Conway, MAN6025DMorgan Joel E · Mcalester, OKN6025EVictor Air LLC · Kirkland, WAN6025FLeeloo Air LLC · Reno, NVN6025PThagair LLC · Reno, NVN6025ZWind River Aviators LLC · Dubois, WYN6026SPhoneix East Aviation LLC · Daytona Beach, FLN6026ZAerodynamic LLC · Aurora, ORN60279Tensco Inc · Twin Falls, IDN6027ZSpacely Space Sprockets LLC · Aurora, ORN6028UDesert Sky Aviation LLC · La Quinta, CAN6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRN602CPCivil Air Patrol · Maxwell Afb, ALN602DDSilver Creek Aviation Services · Fort Worth, TXN602DEPpp Aviation LLC · Jasper, GAN602EREmbry Riddle Aeronautical University Inc · Prescott, AZN602NDRainer Flight Service LLC · Renton, WAN602TCSanderson Kimberly L · Swartz, LAN602TLCoast Flight Training And Management Inc · San Diego, CAN6031LRegistered aircraftN6031WWings Over Texas Holdings LLC · Denton, TXN6032DBravo Gulf Zulu Aviation LLC · Newark, DEN6032THard Times Wy LLC · Helena, MTN6032WKolb Jonah Allan · Underhill, VTN60337Lewis University · Romeoville, ILN6033BRmp Management Co Inc · Rancho Cucamonga, CAN6033KAirborne LLC · Spring Hill, FL
Back to AD 2003-24-13