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.

N28650Loseka Tiger LLC · Columbia, ILBuilt 1978 · S/N AA5B0723 N28651Dass Aaron · Conroe, TXBuilt 1978 · S/N AA5B0724 N28655Straight & Level Aviation LLC · Bradenton, FLBuilt 1978 · S/N AA5B0731 N28657Gutelius Kenneth · Lake Orion, MIBuilt 1978 · S/N AA5B0733 N28658Hadden Aviation LLC · Sylacauga, ALBuilt 1978 · S/N AA5B0734 N28659Timidaiski Daniel · Mikilteo, WABuilt 1978 · S/N AA5B0735 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2865ZCrouder Trevor J · Fairbanks, AKBuilt 1959 · S/N 22-6864 N28663Ramsey Kelly · Argyle, TXBuilt 1978 · S/N AA5B0737 N28664Aces Flying Services LLC · Sanford, NCBuilt 1978 · S/N AA5B0738 N28667Rehberg Eric · Chattanooga, TNBuilt 1979 · S/N 28-7990422 N2866BBulger Edward P · Newburyport, MAS/N 1002 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2866TPacific Coast Air Museum · Santa Rosa, CAS/N 28-7225258 N2866WBowman Field Flying Club Inc · Louisville, KYBuilt 1979 · S/N 28-7916489 N2866XFeller Gerald A · Long Beach, CAS/N 17700266 N28672Woyshnis Kyle · Port Orchard, WABuilt 1978 · S/N AA5B0745 N28678Rubino Daniel A · Marion, KYBuilt 1977 · S/N AA5B0679 N2867AShinkle Robert P · Sugar Creek Twnshp, OHBuilt 1979 · S/N 28-7916491 N2867TN504fl LLC · Killeen, TXBuilt 1972 · S/N 28-7225259 N2867URegistered aircraftS/N 28-7916493 N2867XThrush Air Lc · Mason City, IABuilt 1967 · S/N 17700267 N28682Mcclure Glenn E · Convoy, OHBuilt 1978 · S/N AA5B0754 N28683Siry Steven · Santa Barbara, CABuilt 1978 · S/N AA5B0755 N28684Loveless Anesthesia Pllc · Conway, ARS/N AA5B0756 N28688Jennings Jared Alan · Tacoma, WABuilt 1978 · S/N AA5B0757 N2868DMayer Larry A · Billings, MTBuilt 1987 · S/N 1004 N2868PRedman Adam J · Anchorage, AKS/N 18-4457 N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868 N2868TBooth Gregory · Ferriday, LAFirst renewal noticeBuilt 1972 · S/N 28-7205233 N2868WExecutive Flight Institute LLC · Murrieta, CABuilt 1979 · S/N 28-7990509 N2868YMobile Dev Group LLC · Fair Lawn, NJBuilt 1979 · S/N 28-7990511 N28692Heidi'S House LLC · Woodstock, GABuilt 1978 · S/N AA5B0759 N28696Clark Brian David · Cumming, GAS/N AA5B0761 N28697Saddler Harry · Berkeley, CABuilt 1978 · S/N AA5B0762 N28699Mizner Michael D · Richfield, UTS/N AA5B0764 N2869PAlaska Aviation Museum · Anchorage, AKS/N 18-4459 N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869 N2869ZRolling Rock Equipment LLC · Mount Pleasant, PAS/N 22-6785 N286GRGinal Ronald T DBA · Essex Junction, VTBuilt 1978 · S/N AA5B0763 N286NDMorris Randall Sanford Hartnett · Fort Worth, TXBuilt 2000 · S/N 2844035 N286PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496109 N286YMBug Smasher LLC · Mitchell, SDBuilt 1983 · S/N 286 N28703Barney Diane J · Mojave, CABuilt 1978 · S/N AA5B0765 N28705S & M Aviation Inc · Barefoot Beach, FLBuilt 1978 · S/N AA5B0766 N28706Kalus Joseph G · Afton, WYBuilt 1987 · S/N 1007 N2870DBardsley Lucas A · Sutton, AKBuilt 1987 · S/N 1006 N28712Raduns Deirdre Eychner · Kearneysville, WVBuilt 1978 · S/N AA5B0769 N28719Keleher Daniel Bradley · Orion, ILBuilt 1978 · S/N AA5B0773 N2871PZweifel Douglas L · Anchorage, AKFirst renewal noticeBuilt 1955 · S/N 18-4461

Back to AD 79-10-03 R2