AD 2005-05-53 R1
Registered aircraft · 6,035
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:2005-05-53-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-05-53-R1')
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:2005-05-53-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-05-53-R1') 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.
N182EMPxw Services · Manassas, VAN182GAGaman LLC · Tulsa, OKN182GMBaker Charles W · Lake Worth, FLN182GNWorthington Greg · San Francisco, CAN182HEBronx Girl LLC · Cedar City, UTN182HFCook Daniel E · Gulf Breeze, FLN182HXSkylane Holdings LLC · Kilgore, TXN182HZElings Heath R · Conrad, MTN182JZMercer Fraser Co · Eureka, CAN182LKEllison William G · Telluride, CON182LMCommercial Diving Inc · Melbourne, FLN182LPTristar Aviation Management Nevada LLC · Las Vegas, NVN182MASterling Flight Training LLC · Jacksonville, FLN182MCOwle Aviation LLC · Mount Vernon, WAN182MEMcfann Aiden J · Timnath, CON182MGTurnidge Austin Michael · Seattle, WAN182MUTru Flight Materials LLC · Wilmington, DEN182MVCarpe Diem Aviation LLC · Edgartown, MAN182MWMcadam Brad · Fredericksburg, VAN182NWNorthwestern Michigan College · Traverse City, MIN182PADecicco John Anthony · Clovis, CAN182PFKeehner Sean W Trustee · Pasadena, MDN182PHVan Bortel Aircraft Inc · Arlington, TXN182PMRg Aviation LLC · Fulton, MSN182PPPatch Patricia A Trustee · Titusville, FLN182QAAircraft Guaranty Corp Trustee · Oklahoma City, OKN182RHFinnelly Patrick J · Hunts Point, WAN182RRDont Be Nosy LLC · Fresno, CAN182SJSmj Ventures LLC · North Dighton, MAN182SKSteele David J Trustee · Fullerton, CAN182TCDasko LLC · Louisa, KYN182TSLynch Larry E · West Branch, IAN182VMBergey-Shisler Joanna · Chalfont, PAN182VTStarbros Aviation LLC · Southlake, TXN182WNTyson Stephen E · Marion, IAN1838EAtp Aircraft 6 LLC · Wilmington, DEN1839EAtp Aircraft 6 LLC · Wilmington, DEN183CPCivil Air Patrol · Maxwell Afb, ALN183MKRude Daniel · Leesburg, VAN183NWNorthwestern Michigan College · Traverse City, MIN1842EAtp Aircraft 6 LLC · Wilmington, DEN184AFG & M Aircraft Inc · Wheat Ridge, CON184CACivil Air Patrol · Maxwell Afb, ALN184CPCivil Air Patrol · Maxwell Afb, ALN184NWNorthwestern Michigan College · Traverse City, MIN1859UMustang Sally Aviation LLC · Camden, SCN185CPCivil Air Patrol · Maxwell Afb, ALN186CPCivil Air Patrol · Maxwell Afb, ALN186CSFlying Rock Aero LLC · Sunnyvale, CAN186DTBell Michael · Cameron Park, CA
Back to AD 2005-05-53 R1