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.

N32101Speed Hunter Aviation LLC · Franklin, OHBuilt 1974 · S/N 28-7505024 N32103Freeman David B · Liberty, NCS/N 28-7505026 N32115Kowatra Anil K · Lilburn, GAFirst renewal noticeBuilt 1974 · S/N 28-7505027 N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470 N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152 N32123Kell Matthew D · Kodiak, AKBuilt 1974 · S/N 28-7515076 N32124Howard John D · Palm Bay, FLBuilt 1974 · S/N 28-7515077 N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028 N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443 N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512 N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153 N3214DHill James P · Eagle Point, ORS/N 18-8209025 N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514 N32151Wilson James E III · Brentwood, CAS/N 28-7505030 N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029 N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515 N3215ZCastle Richard E · Callao, MOS/N 22-7155 N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030 N32161Helseth Keith A · Kirksville, MOBuilt 1974 · S/N 28-7515082 N32165Cole Charles V · Sparta, TNBuilt 1974 · S/N 28-7515084 N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031 N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032 N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033 N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031 N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032 N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158 N32181Weaver James D · Montgomery, INBuilt 1974 · S/N 28-7515088 N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092 N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093 N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036 N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321DFFranklin David A · Sealy, TXBuilt 2001 · S/N 570E N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321EFRengel Richard J · Tustin, CAS/N 1900 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202

Back to AD 79-10-03 R2