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.

N4302ZSportsmans Air Service Inc · Anchorage, AKBuilt 1967 · S/N 18-8611 N43037Miloud Chadd K · Fort Worth, TXBuilt 1983 · S/N 28-8316068 N4303ANelund Craig David · Edwardsburg, MIS/N 22-3653 N4303JGroff Paul F · San Leandro, CABuilt 1967 · S/N 28-22674 N4303QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260203 N4303TReem Steven J · Cogan Station, PABuilt 1971 · S/N 28-7225129 N43044Will Eric S · Waseca, MNBuilt 1974 · S/N 28-7405170 N4304AGuslick Michael M · Milwaukee, WIBuilt 1956 · S/N 22-3655 N4304JStetser Nicholas R · Redding, CAS/N 28-22675 N4304QProfessional Aviation Inc · Dalton, GAS/N 17260204 N4304TButler Jeffrey C · Abilene, TXBuilt 1971 · S/N 28-7225131 N43050Essex Air LLC · Franklin Lakes, NJBuilt 1974 · S/N 28-7415415 N43051Luitjens Jacob J · Cascade Locks, ORBuilt 1974 · S/N 28-7415416 N43056Lucier Laura M · Houston, TXBuilt 1983 · S/N 28-8390067 N43057Bogaard Family Partnership · Park Rapids, MNBuilt 1974 · S/N 28-7415418 N4305JThompson Judith P · Loleta, CABuilt 1967 · S/N 28-22676 N4305XKrzykwa Thomas F · Newark, DEBuilt 1975 · S/N 28-7625009 N4305ZMahoney Edmund Mont · Anchorage, AKBuilt 1968 · S/N 18-8614 N43060Jefferson City Aviation Inc · Jefferson City, MOBuilt 1983 · S/N 28-8316074 N4306BPv Rec Flight LLC · West Chester, PABuilt 1983 · S/N 28-8390068 N4306YRegistration Pending · Phoenix, AZRegistration pendingBuilt 1961 · S/N 23-2029 N4307AKennedy Gary R · Sanger, TXBuilt 1956 · S/N 22-3658 N4307MCannon Mark C · Shelbyville, TNBuilt 1983 · S/N 28-8316076 N4307PGibson Kim · Ocean Springs, MSBuilt 1959 · S/N 23-1808 N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060 N4307XHorizon Aviation LLC · Brooks, GABuilt 1975 · S/N 28-7505255 N4307ZDenons Flying Service Inc · Rolling Fork, MSBuilt 1967 · S/N 18-8616 N43080Red Baron Rentals LLC · Jacksonville, FLBuilt 1974 · S/N 28-7415424 N43084Bushby Harvey M · Minooka, ILBuilt 1994 · S/N 7-0206 N43088Registration Pending · Babson Park, FLRegistration pendingBuilt 1974 · S/N 28-7425333 N4308JBuresh George W · Milwaukee, WIBuilt 1967 · S/N 28-22680 N4308KPetsche Renee A · Round Rock, TXFirst renewal noticeBuilt 1983 · S/N 28-8316082 N4308QN4038q LLC · Merritt Island, FLBuilt 1971 · S/N 17260208 N43091Reid Royce · Ferndale, WABuilt 1983 · S/N 28-8390076 N43094Auburn Aeroplane Inc · Ft Wayne, INBuilt 1974 · S/N 28-7415426 N43095Rogers Danny · Florence, KYBuilt 1983 · S/N 28-8390077 N43098Forest City Aviation Inc · Forest City, IABuilt 1974 · S/N 28-7405175 N43099Bennick Frances E · Andreas, PABuilt 1974 · S/N 28-7405176 N4309AParylak Sean P · Colchester, CTBuilt 1956 · S/N 22-3661 N4309JHorn Rodney L · Friendswood, TXBuilt 1967 · S/N 28-22681 N4309PSibille Philippe B · Waller, TXBuilt 1959 · S/N 23-1810 N4309QCamp Harold S Jr · Bossier City, LABuilt 1971 · S/N 17260209 N4309XFizer Charles Sutton IV · Orlando, FLBuilt 1983 · S/N 28-8316086 N4309ZMccue Ryan D · Anchorage, AKBuilt 1967 · S/N 18-8619 N430BSCoyle Christopher Neal · Portland, ORBuilt 1975 · S/N AA5B-0085 N430BZHirschman David M · Ijamsville, MDBuilt 1997 · S/N 1862 N430DHHolbrook Dennis V · New Plymouth, IDBuilt 1998 · S/N 430R N430DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816517 N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355 N430HHuntsinger Robert J · Bothell, WABuilt 1995 · S/N 629

Back to AD 79-10-03 R2