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.

N229ANCalifornia In Nice Inc · San Jose, CABuilt 1982 · S/N 17275587 N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585 N229CN229c LLC · Holt, MOFirst renewal noticeBuilt 1965 · S/N 18256129 N229CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283263 N229CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282293 N229CSChicostate Aviation LLC · Wilmington, DEBuilt 1960 · S/N 52363 N229ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608229 N229LPDuke Air LLC · Romeo, MIBuilt 2003 · S/N 18281229 N229METom Wood Aviation Inc · Fishers, INBuilt 2000 · S/N 172S8483 N229NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 17271323 N229WCJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2016 · S/N 172S11669 N229WWMcgregor Daniel A · Denali Park, AKBuilt 1973 · S/N U20601807 N22BZ8k Investments LLC Series Cessna 150 · Perryton, TXBuilt 1968 · S/N 15068198 N22CRegistered aircraftBuilt 1958 · S/N 51007 N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188 N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217 N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159 N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974 N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168 N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442 N22EPRobinson Michael · Tucson, AZBuilt 1972 · S/N 21059773 N22FBWilson Travis · Beaver Dam, KYS/N 21060634 N22FGState Of California Department Of Fish And Game · Sacramento, CABuilt 1983 · S/N 18504407 N22GCSkydive Ky LLC · Cecilia, KYBuilt 1953 · S/N 30532 N22GPDunkelburg David L · Milton Freewater, ORBuilt 1963 · S/N 58202 N22JNRegistered aircraftBuilt 1979 · S/N 172RG0215 N22KMTorris Warren E · San Dimas, CABuilt 1973 · S/N 21060132 N22MDewitt Josiah · Renton, WABuilt 1962 · S/N 18253788 N22MDHolland Bryan K · Sterling, AKBuilt 1966 · S/N 337-0590 N22NEEvmed LLC · Littleton, NCBuilt 1975 · S/N 21060908 N22NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18263497 N22PNLingle Gordon D · Gun Barrel City, TXBuilt 1966 · S/N 337-0538 N22REStanley Aero Club Inc · Belmont, NCBuilt 1974 · S/N 18263425 N22RWDenison Scott E · Gainesville, TXBuilt 1976 · S/N 17267495 N22SDGordon Scott K Trustee · Tucson, AZBuilt 1968 · S/N 17700892 N22SJWright James M · San Diego, CABuilt 1999 · S/N 172S8345 N22TGChin-Loy Christopher Waynetrustee · Tamarac, FLBuilt 1977 · S/N 21061904 N22WREz Enterprises LLC · Montrose, COS/N 18267626 N22XXHeath Michael A · Barnet, VTBuilt 1958 · S/N 36982 N22ZJSaydun LLC · Richardson, TXS/N F172-0065 N23001Henshaw Edward C · Vian, OKBuilt 1968 · S/N 15068672 N23009Hopkins Francis · Wilmington, DEBuilt 1968 · S/N 15068675 N2300CWasp Air LLC · Hamilton, MTBuilt 1953 · S/N 30600 N2300DEmbry Aero Ltd · Greenville, ILBuilt 1952 · S/N 20452 N2300PNess Dana E · Chester, MTS/N 21057746 N23012De La Fuente Carlo H · Lompoc, CAS/N 15068676 N23015Schalk Rudolph A · Morgan Hill, CABuilt 1968 · S/N 15068678 N23017Kopacz Keith P · Saint Thomas, VIS/N 15068680 N23018Andrews University · Berrien Springs, MIBuilt 1968 · S/N 15068681 N2301XPetritsch Ryan · Warrington, PABuilt 1965 · S/N 18256201

Back to AD 79-10-14 R1