Skip to content

Registered aircraft · 40,397

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.

N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309 N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306 N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612 N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313 N1478XMello Edward R Jr · Land O Lakes, FLBuilt 1975 · S/N 28-7525292 N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735 N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016 N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146 N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411 N147AVRegistered aircraftN-number assigned, not yet registeredS/N 1262 N147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeBuilt 2003 · S/N 447-2003 N147DSDavis Brady · Acampo, CABuilt 1973 · S/N 439 N147EBMalott David · Glade Park, COBuilt 1975 · S/N 20-1165 N147FWParr William R Jr · Mason, TXS/N 80771 N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545 N147JKKuehn John · Sammamish, WABuilt 1999 · S/N 2257 N147JSScrobola James M · Wyoming, PABuilt 2019 · S/N SCROBOLA 0001 N147LFRed Baron LLC · Middletown, DES/N 161 N147MAReaddick Rocy W · Kingsland, GABuilt 2005 · S/N 501-2005 N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000 N147MTMiddle Tennessee State University · Murfreesboro, TNBuilt 1974 · S/N 18-7409136 N147PCAlexander John S · Warrensburg, NYBuilt 2004 · S/N 1366-2004 N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N148DPHenke Kristen C · Bettendorf, IAS/N 11015C N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148LMMoore Shelby L · Mount Pleasant, NCBuilt 2005 · S/N 5494 N148MHSmith Timothy Landon · Jonesville, NCBuilt 2017 · S/N 22570 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282

Back to AD 79-10-03 R2