Registered aircraft · 6,038

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

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

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.

N3552DBarwick H Brooks III · Clinton, NCBuilt 2001 · S/N 18281020 N3552L4wblue LLC · Waccabuc, NYBuilt 2001 · S/N 18281021 N3552QRegistered aircraftBuilt 2001 · S/N 18281022 N3553DM&R Aircraft LLC · Wilmington, DES/N T18208090 N3554EZin Services LLC · Dove, DEBuilt 2001 · S/N 172S8948 N3554PCrimson Enterprises LLC · Wilmington, NCS/N 172S8955 N3555LHillsboro Aero Academy LLC · Hillsboro, ORS/N 172S8865 N3556VWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281009 N3556ZJohnson Paul A Trustee · Bloomfield Hills, MIBuilt 2001 · S/N T18208060 N35578Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8867 N3557EWinged Bullies LLC · Spicewood, TXS/N 17281057 N35583Confluence Systems Consulting Inc · San Jose, CAS/N 172S8872 N3559EGreater Flint Pilots Association Inc · Flushing, MIS/N 18281010 N3559RWest Indies Aviation Corp Trustee · Wilmington, DEBuilt 2001 · S/N 18281011 N355CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281507 N355GMTextron Aviation Inc · Wichita, KSS/N 18283367 N355GWValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 172S9355 N355MEBode Aviation Inc · Albuquerque, NMBuilt 2000 · S/N 172S8590 N3560GVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208063 N3566ASun City Aviation LLC · Davie, FLBuilt 1997 · S/N 17280021 N356BFRegistered aircraftBuilt 2004 · S/N 18281392 N356CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281508 N356DHCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283356 N356ESPremier Flight Center LLC · Hartford, CTBuilt 1997 · S/N 17280051 N357CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281509 N357DWFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9820 N357ESReeno Aviation LLC · Lewisville, NCBuilt 1997 · S/N 17280007 N357HMH & M Aviation LLC · Madison, MSBuilt 2004 · S/N 18281338 N357MGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10259 N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314 N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510 N358ESSoutheastern Veterinary Relief Services LLC · Orange Park, FLBuilt 1997 · S/N 17280008 N358TWTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 172S9751 N359CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281535 N359SPSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 2003 · S/N 172S9500 N359TWDouble Bogey Aviation LLC · Midland, TXBuilt 2004 · S/N 18281477 N35ZQZq Navigation LLC · Bellingham, WABuilt 2023 · S/N 18283244 N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519 N360CWCentral Washington University · Ellensburg, WABuilt 1998 · S/N 17280312 N360ECdw Flyers LLC · Kinnelon, NJBuilt 2022 · S/N 18283198 N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010 N360SPN360sp LLC · Palm City, FLBuilt 2001 · S/N 172S8777 N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840 N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521 N361LRegistered aircraftBuilt 2004 · S/N 172S9569 N361LULewis University · Romeoville, ILBuilt 2020 · S/N 172S12564 N361TKReckless Air LLC · Greenback, TNBuilt 2019 · S/N 18283085 N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013

Back to AD 2005-05-53 R1