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.
N808BPChemtech-Engineering Inc · Racine, WIN808DTGh Aircraft Leasing LLC · Coconut Creek, FLN808DWHall Danny J · Torrington, CTN808PEBarbers Point Flight School LLC · Kapolei, HIN808TPAvian Leasing LLC · Bremerton, WAN808ZTDepartment Of Homeland Security · Washington, DCN809CPCivil Air Patrol · Maxwell Afb, ALN809DWReed Land & Properties LLC · Kalispell, MTN809EMDepartment Of Homeland Security · Washington, DCN809FTextron Aviation Inc · Wichita, KSN809GTDepartment Of Homeland Security · Washington, DCN809HWDepartment Of Homeland Security · Washington, DCN809KPDepartment Of Homeland Security · Washington, DCN809LNDepartment Of Homeland Security · Washington, DCN809NDDepartment Of Homeland Security · Washington, DCN809PGDepartment Of Homeland Security · Washington, DCN809QJDepartment Of Homeland Security · Washington, DCN809RHDepartment Of Homeland Security · Washington, DCN809SEDepartment Of Homeland Security · Washington, DCN809TTDepartment Of Homeland Security · Washington, DCN809USDepartment Of Homeland Security · Washington, DCN809VADepartment Of Homeland Security · Washington, DCN80BFAir Future Airways Corp · Miami, FLN80LULetourneau University · Longview, TXN80PELakepoint Aviation LLC · Augusta, KSN810CAChristiansen Aviation LLC · Wilmington, DEN810CPCivil Air Patrol · Maxwell Afb, ALN810EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN810KKKenzy 2023 LLC · Aurora, ORN810KSFargo Jet Center LLC · Fargo, NDN810RFQuiring Mark Edmond · Mount Pleasant, TXN810SABlack Hound Aviation LLC · Austin, TXN811AFState Of Louisiana · Baton Rouge, LAN811AHOtv Leasing · Manassas, VAN811CAChristiansen Aviation LLC · Wilmington, DEN811CPCivil Air Patrol · Maxwell Afb, ALN811CSSheldon Brent Robert · Warwick, NYN811CTBravo Aircraft LLC · Ooltewah, TNN811EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN811GWGreat Western Aviation Leasing LLC · Ogden, UTN811KSFargo Jet Center LLC · Fargo, NDN811PEPalmito Resources Lc · Dallas, TXN811TWNova Aircraft Holdings Inc · San Diego, CAN812AFState Of Louisiana · Baton Rouge, LAN812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN812HVPinpoint Locating Inc · Altoona, ALFirst renewal noticeN812KSUniversity Of Central Missouri · Warrensburg, MON812MCFly Bye Air LLC · Southport, NCN813CAChristiansen Aviation LLC · Wilmington, DEN813CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2003-24-13