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.

N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855 N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201 N9526JWorthington Brian · Las Vegas, NVBuilt 1966 · S/N 28-3652 N9526LAnderson Jeffrey · Ann Arbor, MIBuilt 1974 · S/N AA5-0526 N9526WMarch Theodore M · Fernley, NVBuilt 1967 · S/N 28-22954 N95270Get Away 1 LLC · St George, UTBuilt 1969 · S/N 28-25870 N95271Ederer Martin J · Baraboo, WIBuilt 1969 · S/N 28-25871 N9527JOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 28-3653 N9527WDieck Michael J · Fayetteville, NCFirst renewal noticeS/N 28-22955 N95285Bangerter James Alan · Indn Hbr Bch, FLBuilt 1969 · S/N 28-25875 N9528DGreenhead Flight Services LLC · Bemidji, MNBuilt 1958 · S/N 22-6444 N9528JGiles Dennis E II · Pearson, WIBuilt 1966 · S/N 28-3654 N9529DHeil Jay E · Brownton, MNBuilt 1958 · S/N 22-6445 N9529LMcdaniel Mark O · Martinsville, INBuilt 1974 · S/N AA5-0529 N9529SRegistered aircraftBuilt 1965 · S/N 331 N952JCCarver Jonathan E · Oxford, NCBuilt 2004 · S/N 5282 N952MKhan Mohsin H · Lodi, CABuilt 1966 · S/N 3364 N952SHNelson Chris · Crown Point, INBuilt 2005 · S/N 3920 N952TBLong Jacob · Bend, ORBuilt 2011 · S/N 25074 N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878 N95303Morrison Robert F II · Denton, TXS/N 28-25879 N95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeBuilt 1969 · S/N 28-25880 N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858 N9530JNations Jeffrey L · Kingshill, VIS/N 28-3657 N9530LClark Dale H · Discovery Bay, CABuilt 1974 · S/N AA5-0530 N9530WGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28-22958 N95315Valencic Adam · Apopka, FLBuilt 1969 · S/N 28-25885 N9531JGrayhawk Flight Training LLC · Lucas, TXBuilt 1966 · S/N 28-3658 N9531LBaker Bob E · Carmichael, CABuilt 1974 · S/N AA5-0614 N95327Seashell Aviation LLC · Milton, FLBuilt 1969 · S/N 28-25889 N95329Jay Stylz Trucking LLC · Cedar Rapids, IABuilt 1969 · S/N 28-25891 N9532DPayne Frederick B · Fayetteville, GABuilt 1958 · S/N 22-6448 N9532JHarris Jason L · Clanton, ALFirst renewal noticeBuilt 1966 · S/N 28-3659 N9532LShattuck Charles W · Goshen, CTBuilt 1974 · S/N AA5-0532 N9532WRodriguez Santos Jr · West Plains, MOS/N 28-22960 N9533JWadel Ronald A · Shippensburg, PABuilt 1966 · S/N 28-3660 N95343Obert Megan E · Hartselle, ALBuilt 1969 · S/N 28-25896 N95346Jackson Douglas A · Cynthiana, KYBuilt 1969 · S/N 28-25512 N95347Jora Imports LLC · Atlanta, GABuilt 1969 · S/N 28-25728 N9534DLevinson Isaac F · White Salmon, WAS/N 22-6450 N9534HBotezatu Florin · Gig Harbor, WABuilt 1975 · S/N 17266208 N9534JTock Robert · Saint Paul, MOBuilt 1966 · S/N 28-3661 N9534LPowley Robert L · Mahwah, NJS/N AA5-0534 N9535HNorthwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17266209 N9535JBradley D Schnell · Mequon, WIBuilt 1966 · S/N 28-3662 N9535WEast Carolina Aviation LLC · Camden, NCBuilt 1967 · S/N 28-22964 N95364Hostetler Joseph A · Brownsburg, INBuilt 1969 · S/N 28-25900 N95365Mason Brent M · Clarksville, FLBuilt 1969 · S/N 28-25734 N95369Szmurlo Steven R · Easton, PABuilt 1969 · S/N 28-25901 N9536HSampson Kelly J · Canby, ORS/N 17266210

Back to AD 79-10-03 R2