Skip to content

Registered aircraft · 40,396

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.

N57WS4031 Aviation Inc · Bemidji, MNS/N 18-5463 N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880 N5802LHarrold Michael C · Hamilton, MTBuilt 1971 · S/N AA5-0002 N5803EIrwin Donald L · Emporia, KSBuilt 1978 · S/N 17271938 N5803PLaskey Steven W · Littleton, COBuilt 1959 · S/N 24-883 N5803WClifford William M · North East, MDBuilt 1964 · S/N 28-1877 N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134 N5804LAa Horizons LLC · League City, TXBuilt 1971 · S/N AA5-0004 N5804QMoffet Jeffrey C · Lawrence, KSS/N 3111 N5804USand Piper Air LLC · Endicott, NYBuilt 1970 · S/N 28-26632 N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204 N5804WBard Nathan R · Carlisle, PABuilt 1964 · S/N 28-1895 N5805DEasley Clarence E · Pleasanton, KSS/N 22-4480 N5805UFoxtrot Three Flying Services LLC · Henderson, NVBuilt 1970 · S/N 28-26633 N5805WPackett Robert E · Silverdale, WAFirst renewal noticeBuilt 1964 · S/N 28-1897 N5806LSutphin Christoper F · Darlington, SCS/N AA5-0006 N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205 N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887 N5808LChristensen Donald R · Anchorage, AKBuilt 1971 · S/N AA5-0008 N5808QSaathoff Michael A · Stockton, MOBuilt 1965 · S/N 3113 N5808WYoung Victor G · Federal Way, WABuilt 1964 · S/N 28-1922 N5809LNealy William · Heath, TXS/N AA5-0216 N5809WRegistered aircraftBuilt 1964 · S/N 28-1926 N580FLWaves4days LLC · El Segundo, CABuilt 1971 · S/N 28-7125433 N580JGRewerts Glen D · Berthoud, COBuilt 2011 · S/N 72816 N580MStockman Harold O · Elko, NVBuilt 1998 · S/N 24580 N580SUMetro Aviation Inc · Shreveport, LABuilt 1981 · S/N 172RG0877 N5810USmith Herbert E · Rochelle, ILBuilt 1969 · S/N 28-26638 N5811EMoss Jessee C · Ardmore, OKBuilt 1978 · S/N 17271941 N5811QElliott Areospace LLC · Kalispell, MTBuilt 1965 · S/N 771 N5812LLindly Lowell J · Nashville, ARBuilt 1971 · S/N AA5-0012 N5812USeymour Lori L · Woodstock, GABuilt 1969 · S/N 28-26641 N5813WStothers Brian · Lake Havasu City, AZBuilt 1964 · S/N 28-1954 N5814DMessinger Donald C · Wasilla, AKBuilt 1956 · S/N 22-4489 N5814UAnderson Timothy B · Cold Spring, KYBuilt 1970 · S/N 28-26644 N5814WP&K Enterprises LLC · Madison Heights, VABuilt 1964 · S/N 28-1965 N5815LFidler Richard · San Francisco, CABuilt 1972 · S/N AA5-015 N5815UMiller William W Jr · Henderson, NVBuilt 1969 · S/N 28-26643 N5816DTurner Robert E · Talladega, ALBuilt 1956 · S/N 22-4491 N5816LSparrowhawk Aviation LLC · Moraine, OHFirst renewal noticeBuilt 1972 · S/N AA5-0016 N5816QHigh Flying Vision LLC · Clarksdale, MSBuilt 1965 · S/N 3117 N5816UHarsimran Singh · Las Vegas, NVBuilt 1970 · S/N 28-26645 N5817WDow Jeff W · Port Hadlock, WABuilt 1964 · S/N 28-1988 N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494 N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219 N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649 N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997 N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811 N581JDAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 21912 N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115

Back to AD 79-10-03 R2