Skip to content

Registered aircraft · 40,394

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.

N98116Goncalves Ildo Depina · Brockton, MABuilt 1969 · S/N 28-26052 N9811UHoxworth William D · Westminster, COBuilt 1976 · S/N AA5A-0211 N9811VSteffek Mark E · Alturas, CABuilt 1974 · S/N 17264511 N9811WAbove The Best Consulting LLC · Clarksville, TNS/N 28-23311 N98120Blue River Aviation LLC · Palmer, AKBuilt 1984 · S/N 17276260 N98125Western Reserve Flight Center Inc · Mc Donald, OHBuilt 1984 · S/N 17276261 N98127Lucas James J · Rossville, TNBuilt 1969 · S/N 28-26058 N9812CHodgs Sidney L · Cimarron, KSBuilt 1978 · S/N 28-7890445 N9812JMelbourne Flight Training LLC · Melbourne, FLBuilt 1980 · S/N 17273920 N9812WSaylor Herbert R · Dover, DEBuilt 1967 · S/N 28-23312 N98131Registered aircraftBuilt 1969 · S/N 28-26059 N98134Stanly Business Consultants LLC · Albermarle, NCS/N 28-26064 N98135Tropical Island Aircraft LLC · Clearwater, FLBuilt 1969 · S/N 28-26065 N98136Tringale Alison T · Port Saint Joe, FLBuilt 1969 · S/N 28-26066 N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616 N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512 N9813WAdelza Group Holdings LLC · Orlando, FLBuilt 1967 · S/N 28-23314 N9814CZechlin Margaret Christine · Novato, CABuilt 1978 · S/N 28-7890446 N9814DGupton Scott W · Prescott Valley, AZBuilt 1959 · S/N 22-6701 N9814PBeardsley Taylor J · Miles City, MTFirst renewal noticeBuilt 1976 · S/N 18-7609033 N98150Schaulin Frederick S · Fort Collins, COBuilt 1969 · S/N 28-26075 N98151Margulies Isaiah · New Orleans, LABuilt 1969 · S/N 28-26076 N98152Smith Austin M · Prescott, AZBuilt 1969 · S/N 28-26077 N98158Weber Lawrence D · Fairfield, ILBuilt 1969 · S/N 28-26079 N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715 N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618 N9815UHonsinger Gary · Wesley Chapel, FLBuilt 1976 · S/N AA5A-0215 N98161Gentis Tyler A · Riverside, CABuilt 1969 · S/N 28-26081 N98167Hileman Theodore D · Burbank, WABuilt 1969 · S/N 28-26084 N98168Wankel David · Beardstown, ILS/N 28-26083 N9816DWierda Evert T · Manhattan, MTBuilt 1959 · S/N 22-6703 N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716 N9816UCheetah Air LLC · Edinburg, NDBuilt 1976 · S/N AA5A-0216 N98171Aberdeen School District · Aberdeen, MSBuilt 1969 · S/N 28-26085 N98176Bluewater Airmotive Corp · Wilmington, DEBuilt 1969 · S/N 28-26088 N98186Loyer Jeffrey W · Olympia, WAS/N 17276265 N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718 N9818UGainous David C · Port Saint Joe, FLBuilt 1976 · S/N AA5A-0218 N9818W98x LLC · Caddo Mills, TXBuilt 1967 · S/N 28-23320 N98190Coastal Air Inc · Groton, CTFirst renewal noticeBuilt 1969 · S/N 28-26094 N98192N98192 LLC · Dunnellon, FLBuilt 1969 · S/N 28-26095 N98194Christensen-Glanz Melanie · Polson, MTS/N 28-26097 N98196Triplett Robert B · Uniontown, OHBuilt 1969 · S/N 28-26252 N9819UFruehwirth Kevin · Spring, TXBuilt 1976 · S/N AA5A0219 N981ACOtterback Nicholas L · Unionville, TNBuilt 2015 · S/N 60341 N981CMClaypool James W · Hunts Point, WABuilt 1998 · S/N 1247-98 N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239 N981SHSmith Helicopters Inc · Cotulla, TXBuilt 1998 · S/N 2791 N981SLRotor Technologies Inc · Nashua, NHBuilt 1998 · S/N 2871 N981SUHoloubek Mark R · David City, NEBuilt 1975 · S/N 28-7505252

Back to AD 79-10-03 R2