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.

N810KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281244 N810RFQuiring Mark Edmond · Mount Pleasant, TXBuilt 2012 · S/N 18282329 N810SABlack Hound Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9422 N811AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281196 N811AHOtv Leasing · Manassas, VABuilt 2010 · S/N 18282240 N811CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13359 N811CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281248 N811CSSheldon Brent Robert · Warwick, NYBuilt 2012 · S/N T18209081 N811CTBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12492 N811EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12958 N811GWGreat Western Aviation Leasing LLC · Ogden, UTBuilt 2002 · S/N 18281101 N811KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281245 N811PEPalmito Resources Lc · Dallas, TXBuilt 2007 · S/N T18208731 N811TWNova Aircraft Holdings Inc · San Diego, CABuilt 2002 · S/N 18281118 N812AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281197 N812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12797 N812KSUniversity Of Central Missouri · Warrensburg, MOBuilt 2005 · S/N 17281246 N812MCFly Bye Air LLC · Southport, NCBuilt 2003 · S/N 18281208 N813CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13362 N813CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281249 N813EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12818 N813GFChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 17281588 N813HCGeorgia Forestry Commission · Macon, GABuilt 2004 · S/N 18281460 N813KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281247 N814CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13364 N814EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13184 N814FARivinius Sam · Danville, CABuilt 2003 · S/N T18208214 N814FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12456 N814HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280814 N814KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281248 N814MVSterling Flight Training LLC · Jacksonville, FLBuilt 2005 · S/N 172S9965 N814SAMarion Military Institute · Marion, ALBuilt 2002 · S/N 17281114 N815CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281250 N815CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281257 N815DZBlue Sky LLC · Overland Park, KSBuilt 2001 · S/N 18280985 N815EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12660 N815KSPenner Bruce Wade · Hot Springs, SDBuilt 2000 · S/N 17280910 N815SPPlane Fun Inc Tr Trustee · Snellville, GABuilt 2001 · S/N 172S8732 N816ARCustom Curb Inc · Ventura, CABuilt 2005 · S/N T18208451 N816CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281251 N816EPFlight Leasing Corp · Wilmington, DEBuilt 2016 · S/N 172S11724 N816EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12822 N816FATemm 2000 Inc · Arcola, ILBuilt 2002 · S/N 18281116 N816HAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280825 N816JHIndy Aviation LLC · Carmel, INBuilt 2001 · S/N 18280982 N816KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13394 N816KWChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10601 N816RDHoffman Aeronautics LLC · Sedalia, COBuilt 2023 · S/N 172S12987 N816SWUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10576 N816TRGood Day Holdings LLC · Sheridan, WYBuilt 2022 · S/N 18283173

Back to AD 2005-05-53 R1