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.

N215AFArmed Forces Aero Club · San Diego, CABuilt 1978 · S/N 17270844 N215CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13074 N215DJGreat Plains Aviation LLC · Scott City, KSBuilt 2005 · S/N 18281622 N215FRJjg Aviation LLC · Miami, FLBuilt 1978 · S/N 17271822 N215HGGazzaz Hussein · Lakeway, TXBuilt 2025 · S/N 18283328 N215HRLld Inc · Sarasota, FLBuilt 2003 · S/N 172S9527 N215JInnovative Aerodynamic Technologies · Yorktown, VAS/N 21059226 N215LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9215 N215RGGonzalez Rogiero A · San Antonio, TXBuilt 1979 · S/N 18266883 N21608Mmt87 LLC · North Miami, FLBuilt 2003 · S/N 18281286 N2160DSamper Katherine · Miami, FLBuilt 2003 · S/N 172S9547 N2160QSo Cal Leasing LLC · El Cajon, CAS/N 172S9546 N2160RPaper Plane LLC · Hotchkiss, COBuilt 1964 · S/N 18255360 N2160SGalkin Edwin N Dmd · Edison, NJBuilt 1975 · S/N 21061121 N2160YOcala Aviation Services Inc · Ocala, FLBuilt 1962 · S/N 17249660 N21616Joseph Tamar Bar · Chanute, KSBuilt 1972 · S/N 18800910 N21618Schwend Brian · Forsyth, MTBuilt 1972 · S/N 18800912 N2161EBryn Terry P · Dazey, NDBuilt 1978 · S/N 17271172 N2161PRegistered aircraftBuilt 2004 · S/N 18281321 N2161QSalty Dawg Aircraft Inc · Gasport, NYBuilt 1974 · S/N 177RG0561 N2161RKlemme Aviation LLC · Davenport, IABuilt 1964 · S/N 18255361 N21621Csa Aircraft Leasing LLC · Salt Lake City, UTS/N 172S9530 N21624Ellis Archer A · Shady Shores, TXFirst renewal noticeS/N 18281277 N21626Low Level Aero LLC · Myakka City, FLS/N 18800917 N21627Beach David S Trustee · Amherst, NHBuilt 2004 · S/N 172S9575 N2162GOdiorne Bruce Lamar II · Durango, COBuilt 1958 · S/N 51462 N2162LN2162l LLC · Tyler, TXBuilt 2005 · S/N 18281662 N2162ZBaker Benjamin K · Anchorage, AKS/N 18051262 N2163JPortland Police Bureau · Portland, ORBuilt 2003 · S/N 18281279 N2163RRupp Michael David · Lunenburg, MABuilt 1964 · S/N 18255363 N2163SOlde Towne Transport LLC · Beaufort, NCBuilt 2007 · S/N 20608285 N2163ZHennis Jesse J · Nampa, IDBuilt 1963 · S/N 18051263 N21641Bunger William D · Upland, NEBuilt 1972 · S/N 18800927 N21643A&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1974 · S/N 17263982 N21648Fox Victor Aviation LLC · Newnan, GAS/N 17263983 N21651Syverson Ronn · Mcintosh, MNBuilt 1972 · S/N 18800934 N21653Skyhawk Holdings LLC · Waco, TXBuilt 2005 · S/N 18281664 N2165EMaravel Richard N · Trinity, FLBuilt 1978 · S/N 17271174 N2165GStanley Aviation LLC · Stanley, NDS/N 34887 N2165RSproket Industries Inc · Fulton, CABuilt 1964 · S/N 18255365 N2165ZRegistered aircraftBuilt 1963 · S/N 18051265 N21662Smedley Jonathan G · Leander, TXBuilt 2004 · S/N 172S9647 N2166QLiberty Partners Inc · Okmulgee, OKBuilt 1974 · S/N 177RG0566 N2166RKrom Raymond L · Brighton, MIBuilt 1964 · S/N 18255366 N2166ZCherry William Wallace Jr · Muldoon, TXBuilt 1963 · S/N 18051266 N21670Kingsky Flight Academy LLC · Lakeland, FLBuilt 2004 · S/N 172S9709 N2167CStarkys Equipment Leasing LLC · Manchester, MIBuilt 1978 · S/N 17702743 N2167ESittler Charles A · Tulsa, OKS/N 17271176 N2167GBtp Inc · Missoula, MTBuilt 1958 · S/N 51467 N2167PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608217

Back to AD 79-10-14 R1