Skip to content

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

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

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.

N159FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282065 N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816 N159KMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609606 N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258 N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333 N15MJRegistered aircraftBuilt 2024 · S/N 172S13005 N15MVAir Bellers Inc · Sunnyvale, CABuilt 2017 · S/N 18282388 N15SZZurcher Susan R · Hampshire, ILBuilt 2022 · S/N 18283202 N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905 N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907 N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440 N160TTStraightline Private Air LLC · Denver, COBuilt 2017 · S/N T20609505 N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910 N161CSAlberco LLC · Lovell, MEBuilt 2013 · S/N T20609101 N161SPCalifornia Department Of Parks And Recreation · Mcclellan, CABuilt 2021 · S/N T20609667 N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315 N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912 N1624Going Somewhere LLC · Dover, DEBuilt 2018 · S/N 18283056 N162CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13489 N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192 N162JKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13466 N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442 N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164 N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163 N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492 N163CTRenson Travel LLC · San Antonio, TXBuilt 2016 · S/N 18282390 N163DDN163dd LLC · Columbus, MTBuilt 2007 · S/N T18208707 N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715 N163MEAircraft Owners And Pilots Association Inc · Frederick, MDBuilt 2000 · S/N 172S8444 N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753 N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754 N1646CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11729 N1648CCoast Aviation LLC · Costa Mesa, CABuilt 2016 · S/N 172S11678 N164BDRuffin Robert L Jr · Mabank, TXBuilt 2004 · S/N 18281459 N164CWMudd Joe · Tucson, AZBuilt 2004 · S/N 18281325 N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064 N1651CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11755 N1658CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11756 N165ARLago Enterprises LLC · Centennial, COBuilt 1998 · S/N 172S8018 N165CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281865 N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752 N1664CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11757 N1668CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11758 N166CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N T18208319 N166CSAtp Aircraft 7 LLC · Wilmington, DEBuilt 2016 · S/N 172S11664 N166PAMacmillan Performance LLC · Torrance, CABuilt 2012 · S/N T18209060 N1671CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11759 N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915

Back to AD 2003-24-13