Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442 N162NRBurlington Technical Center · Burlington, VTBuilt 1957 · S/N 32805 N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N162WTFly Whiskey Tango 2 LLC · Scottsdale, AZBuilt 1984 · S/N 17276202 N1630CRjd Flyers LLC · Mount Juliet, TNBuilt 1953 · S/N 30330 N1630YHart Gregory D · Medford, ORBuilt 1962 · S/N 17249330 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1632CWarren Mark W · Arlington, WABuilt 1953 · S/N 30332 N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074 N1632FBastion Allen L · Conton, PAS/N 17255027 N1632MD&J Training Planes LLC · Logan, UTBuilt 1975 · S/N 18264398 N1633MHill David A · North Ridgeville, OHBuilt 1975 · S/N 18264399 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N1634DBlackhawk Aviation LLC · Medicine Park, OKBuilt 1952 · S/N 20276 N1634FWings & A Prayer Gso LLC · Weaverville, NCBuilt 1966 · S/N 17255029 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1634YWager Douglas K · Mobridge, SDBuilt 1962 · S/N 17249334 N1636DDeruiter Don DBA · Lake City, MIBuilt 1952 · S/N 20278 N1636FRolfe Harold B Trustee · Holtville, CABuilt 1966 · S/N 17255031 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1636YHokanson Anthony Drake · La Crosse, WIBuilt 1962 · S/N 17249336 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077 N1637FLaminar Skies Aviation LLC · Broken Arrow, OKS/N 17255032 N1637YSmartt Kevin M · Springfield, TNBuilt 1962 · S/N 17249337 N1638FKeith Frye · El Dorado, KSS/N 17255033 N1638QBeck Michael C · Farmington, CTBuilt 1971 · S/N 15072938 N1639DVoigt Don M · Palmer, AKBuilt 1952 · S/N 20281 N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122 N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492 N163CTRenson Travel LLC · San Antonio, TXBuilt 2016 · S/N 18282390 N163HJ&L Asset Holdings LLC · Biloxi, MSBuilt 1957 · S/N 34049 N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715 N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645 N163MCCriddle Michael J · Baker, FLBuilt 1963 · S/N 17250149 N163MEAircraft Owners And Pilots Association Inc · Frederick, MDBuilt 2000 · S/N 172S8444 N163RHHollis Richard H · Auburn, MES/N 18051307 N163WDavis Paul J Jr · Springdale, ARBuilt 1956 · S/N 27094 N1640DRoessler Larry J · Groveland, CABuilt 1952 · S/N 20282 N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078 N1640YHall Justin J · Bellevue, NEBuilt 1962 · S/N 17249340 N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753 N1642FRomeo Kilo Golf LLC · Asheville, NCBuilt 1966 · S/N 17255037 N1642QTochman Andrew J · Avon Lake, OHBuilt 1971 · S/N 15072942 N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754 N1643DMaselko Jacek · Juneau, AKBuilt 1952 · S/N 20285 N1643YLehman Patrick A · Phillips, WIBuilt 1962 · S/N 17249343 N1644CAero 290 LLC · Burlington, WIBuilt 1953 · S/N 30344 N1644EMountain Flyers Inc · Hendersonville, NCBuilt 1979 · S/N 17271079

Back to AD 79-10-14 R1