Skip to content

Registered aircraft · 56,580

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.

N42871Registered aircraftBuilt 1968 · S/N 18259226 N42874Kloker Daniel E · Owasso, OKBuilt 1968 · S/N 18259227 N42875Bowes Tyler D · Fremont, OHBuilt 1968 · S/N 18259228 N42876Norcal Flight Center LLC · Lincoln, CABuilt 1968 · S/N 18259229 N42877Allain Patrick C · Brusly, LABuilt 1968 · S/N 18259230 N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187 N42887Bratlien Michael D · Aurora, COBuilt 1968 · S/N 18259234 N42888Ahigian Craig S · Laguna Niguel, CABuilt 1968 · S/N 18259235 N42889Fuller Lawrence A · Wasilla, AKBuilt 1973 · S/N 18052382 N4288PMooradian Edward M · Fowler, CABuilt 1968 · S/N 18259194 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188 N4288UPiper Kenneth R · Orwell, VTBuilt 1964 · S/N 15060288 N4288VPeck Kenneth L · Smithville, TXBuilt 1948 · S/N 18646 N42893Registration Pending · El Paso, TXRegistration pendingBuilt 1968 · S/N 18259239 N42894Comal Aero Inc · Schertz, TXBuilt 1968 · S/N 18259240 N42898Perera Austin L · Barnstable, MABuilt 1968 · S/N 18259242 N42899Smith Charles Max · Canon City, COBuilt 1968 · S/N 18259243 N4289VRosborough Todd · Medford, ORBuilt 1948 · S/N 18647 N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917 N428BLFlying Money Pit LLC · Des Moines, IABuilt 1965 · S/N 18256552 N428CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8690 N428DWArizona Cloudbusters Inc · Mesa, AZBuilt 2001 · S/N 172S8708 N428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11451 N428FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281228 N428HSSchroebel John Daniel Trustee · Pleasant Hill, CABuilt 1965 · S/N 18256735 N428LBMam Aviation LLC · New York, NYBuilt 2006 · S/N 18281813 N428MTNby Productions · Manassas, VABuilt 2010 · S/N 18282234 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLBuilt 2005 · S/N 172S10058 N42907Albion Telephone Co · Albion, IDBuilt 1968 · S/N 18259247 N4290FRussi Kent S · Caldwell, IDBuilt 1958 · S/N 46190 N42911Kenney Stuart C · Atlanta, GABuilt 1968 · S/N 18259249 N42912Forouzan Fardad Trustee · Poway, CAS/N 18259250 N42916Nedwick Lars I · Girdwood, AKS/N 18052384 N42919Tarnutzer Aviation LLC · Wayland, MIBuilt 1968 · S/N 18259253 N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360 N4291QRegistered aircraftBuilt 1976 · S/N U20603043 N4291UTheis Industrial Leasing Inc · Spivey, KSBuilt 1963 · S/N 15060291 N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4292UHayes John Lue · Shady Cove, ORFirst renewal noticeBuilt 1963 · S/N 15060292 N4292VPowers James E · Elk, WABuilt 1948 · S/N 18650 N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N4293UKelly Reginald David · Morehead City, NCBuilt 1964 · S/N 15060293 N42941Nistler Steve W · Helena, MTS/N 18259259 N42947N42947 LLC · Panama City, FLBuilt 1968 · S/N 18259262 N42949Niemeyer Donald C DBA · Hobart, INBuilt 1968 · S/N 18259263 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4294VDekryger John · Fremont, MIBuilt 1948 · S/N 18652

Back to AD 79-10-14 R1