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.

N1430HHardy John R · Wasilla, AKBuilt 1949 · S/N 15AC-493 N1430VStillwater Aviation LLC · Winter Haven, FLBuilt 1974 · S/N 17263572 N14310Pa-18 LLC · Hood River, ORBuilt 1982 · S/N 18-8309023 N14311Hodgskiss Ben · Choteau, MTS/N 18-7409075 N14312Thomas Charles M Jr · Fairbanks, AKBuilt 1974 · S/N 18-7409067 N14313Morford Brian D · Brandon, SDBuilt 1958 · S/N 18-6357 N14314Boich Mike · Pacific Palisades, CABuilt 1974 · S/N 18-7409076 N14315Orion Works Ltd · Denali Park, AKBuilt 1975 · S/N 18-7609012 N14316Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18-7409077 N14318Boehmlehner Steven A · Rosholt, SDBuilt 1974 · S/N 18-7409081 N1431AKoiter Jason A · Prescott Valley, AZBuilt 1951 · S/N 22-347 N1431BPa-18 LLC · Hood River, ORBuilt 1955 · S/N 18-4562 N1431DPa-18 LLC · Hood River, ORBuilt 1956 · S/N 18-5303 N1431ULa Mooneytte LLC · Seabrook, SCBuilt 1976 · S/N 17267098 N1431VKgrb LLC · Owensville, MOBuilt 1975 · S/N 17263677 N14321Njb Aviation Holdings LLC · Stevens Point, WIBuilt 1974 · S/N 18-7409080 N14326Osprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18-7409086 N14329Wise John H · Naknek, AKBuilt 1975 · S/N 18-7609014 N1432MLarson Sean P · Fairbanks, AKS/N 23-432 N1432PBlue Skies Leasing Inc · Port Orange, FLBuilt 1980 · S/N 17274334 N1432TSmith David · Belleville, ILBuilt 1972 · S/N 28-7205296 N14332Lehner Christopher E · Battle Ground, WABuilt 1974 · S/N 18-7409090 N14333Currin Tom · Pendleton, ORBuilt 1974 · S/N 18-7409091 N1433XEchota Flyers Inc · Calhoun, GAS/N 28-7515406 N14365Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18-7409092 N1436UCloud One Flying Club Inc · Kansas City, MOBuilt 1976 · S/N 17267103 N1437TBenazzi Wahiba · Frisco, TXS/N 28-7225514 N1438CTony And Oats Great Adventure LLC · Danville, INBuilt 1977 · S/N 17702727 N1438PTri Rotor Spray & Chemical · Ulysses, KSS/N 23-496 N1438USale Reported · Greeley, COSale reportedBuilt 1976 · S/N 17267105 N14395Eastern Stearman Inc Trustee · Leesburg, VABuilt 1974 · S/N 18-7409093 N1439UCass Aviation LLC · Henderson, NVBuilt 1976 · S/N 17267106 N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301 N143AMMcgee Ronald S · Las Vegas, NVBuilt 1997 · S/N 1081 N143BHTappan Holdings Inc · Cadiz, OHS/N 21003C N143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792 N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CC N143CHHiers Craig L · Moultrie, GABuilt 1978 · S/N 3562 N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119 N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348 N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178 N143HPDans Aircraft Repair LLC · Gardiner, MTS/N NF0007 N143JDHarris Steven V · Springtown, TXFirst renewal noticeS/N 8083C N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358 N143LKRobbins Larry K · La Follette, TNBuilt 1994 · S/N 190 N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004 N143PSDrake Barbara A · Pensacola, FLBuilt 1986 · S/N 045 N143RVLefevre Garrett R · Tucson, AZBuilt 1998 · S/N 22143 N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993 N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579

Back to AD 79-10-03 R2