Skip to content

Registered aircraft · 10,638

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:99-01-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1') 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:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  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:99-01-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
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.

N1423ZVan Buskirk Bill J · Wasilla, AKBuilt 1952 · S/N 18-1924 N1424AStacey Steve L · Hutchinson, KSBuilt 1951 · S/N 22-338 N14255J T Howell And Son LLC · Jackson, LABuilt 1974 · S/N 18-7409058 N14269Andersen Roger · Curtis, NEBuilt 1974 · S/N 18-7409059 N1427CGdm Properties LLC · Huron, OHBuilt 1953 · S/N 22-1179 N1428CHolder Ward S · Oxnard, CARegistration revokedBuilt 1953 · S/N 22-1180 N14298Campbell Kenneth D · Soldotna, AKBuilt 1974 · S/N 18-7409062 N14299Compton John D · Morgan, UTBuilt 1974 · S/N 18-7409064 N1429CLarge Jonathan B · Mahnomen, MNBuilt 1953 · S/N 22-1183 N1429VTeed Brad S · Vancouver, WAS/N 11-339 N142TReed Britt A · White Salmon, WABuilt 1953 · S/N 18-2256 N14303Fejes William C · Seward, AKS/N 18-7409068 N14304Sterrett Larry D · Havre, MTBuilt 1974 · S/N 18-7409065 N14305Vinton Daniel H · Whitman, NEBuilt 1974 · S/N 18-7409069 N14309Metz Daniel J · Brighton, COBuilt 1971 · S/N 18-7409073 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 N14319Erickson Mark D · Valley Springs, SDS/N 18-6359 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 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 N14332Lehner Christopher E · Battle Ground, WABuilt 1974 · S/N 18-7409090 N14333Currin Tom · Pendleton, ORBuilt 1974 · S/N 18-7409091 N1434CSherman Jeff Co Ow · Elkhart, INRegistration revokedBuilt 1953 · S/N 22-1189 N14365Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18-7409092 N1437CChilders Daniel A · Hartwell, GAS/N 22-1192 N14395Eastern Stearman Inc Trustee · Leesburg, VABuilt 1974 · S/N 18-7409093 N14398Dyke Milo D · Hazen, NDBuilt 1949 · S/N 14-516 N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CC N143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705 N143RUpson Theodore C · Newport, NYBuilt 1947 · S/N 11-1520 N143TMurray Paul M Trustee · Storm Lake, IABuilt 1953 · S/N 18-2257 N1440CChamberlain Howard D · Lisbon, OHBuilt 1953 · S/N 22-1194 N1441CTroyer Cody L · Macon, MSS/N 20985 N144JMBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1967 · S/N 18-8589 N144JWWarren Joy A · White Lake, MIS/N 22-7286 N1451Shaughnessy Thomas E · Seabrook, NHBuilt 1953 · S/N 18-2259 N1456AMcbride Michael S · Allentown, PABuilt 1951 · S/N 22-359 N1456CBrewer Alfred D · Hillsboro, ORBuilt 1953 · S/N 18-2654 N1457ASanderson Michael E · Newberg, ORS/N 22-357 N1458CKohlhase Kent E · Anchorage, AKBuilt 1953 · S/N 18-2657

Back to AD 99-01-05 R1