Skip to content

Registered aircraft · 40,395

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N2857PSale Reported · Greeley, COSale reportedBuilt 1979 · S/N 28-7990501 N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857 N28583Mcgee Michael R · Mamou, LABuilt 1977 · S/N AA5B0691 N28584Cereal City Flying Club LLC · Battle Creek, MIBuilt 1977 · S/N AA5B0692 N2858PSiegfried Richard W · Downers Grove, ILBuilt 1955 · S/N 22-3159 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855 N28591Toher Wayne R · Danbury, CTBuilt 1977 · S/N AA5B0696 N28593Mcmillan David S · Rangeley, MEBuilt 1978 · S/N AA5B0697 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N2859TGouda Rafik M · Rancho Cucamonga, CABuilt 1972 · S/N 28-7225254 N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97 N285HCStiller Mark R · Anchorage, AKBuilt 1960 · S/N 18-7464 N285JACarroll Aviation Inc · Carroll, IABuilt 1997 · S/N 2843105 N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035 N285MKPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2842201 N285PDennin Michael E · Minden, LABuilt 1968 · S/N 28-24804 N285TARegistration Pending · Augusta, KSRegistration pendingBuilt 1977 · S/N 28-7716239 N28604Quest Technical Sales & Marketing Inc · Westlake Village, CABuilt 1978 · S/N AA5B0701 N2860PSchwend Brian · Forsyth, MTBuilt 1955 · S/N 18-4447 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232 N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857 N28610Brown Ryan O · Columbia, TNBuilt 1977 · S/N AA5B0677 N28618Morgan Robert J · Mojave, CABuilt 1978 · S/N AA5B0707 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N28622Cole Quentin P · Huntingdon Valley, PABuilt 1978 · S/N AA5B0708 N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420 N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486 N2862XMathews Nancy M · Englewood, TNS/N 17700262 N28630Flying Tiger LLC · Chesapeake, VABuilt 1978 · S/N AA5B0711 N28631Perry Colin C · Petaluma, CABuilt 1978 · S/N AA5B0712 N28633Fritz William J · Carnesville, GABuilt 1978 · S/N AA5B0713 N28634Wolvin Michael S · N Fort Myers, FLBuilt 1978 · S/N AA5B0714 N28635N28635 LLC · Harding, PABuilt 1978 · S/N AA5B0715 N28637Rust Scott Allen · Indianapolis, INBuilt 1978 · S/N AA5B0716 N28639International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N AA5B0718 N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352 N2863MBaillie Ryan B · Hermitage, TNBuilt 1977 · S/N 28-7816318 N2863PGic Inc · Oneill, NEBuilt 1979 · S/N 28-7990504 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2863UEady Paul Clifford · Lakeside, CABuilt 1979 · S/N 28-7990505 N2863VBfree2fly LLC · Delaware, OHBuilt 1979 · S/N 28-7990506 N2863ZWhitaker Eric L · Detroit, TXS/N 22-6862 N28641Cpr Pacific LLC · Salinas, CABuilt 1978 · S/N AA5B0719 N28646Kutok Stephen M · Commack, NYBuilt 1978 · S/N AA5B0721 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2864WSpearhead Ranch LLC · Douglas, WYBuilt 1987 · S/N 1001 N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264 N2864ZUecker Todd M · Port Townsend, WABuilt 1959 · S/N 22-6871

Back to AD 79-10-03 R2