Registered aircraft · 10,639

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.

N88MDWaage Matthew L · Elkhart Lake, WIBuilt 1955 · S/N 18-4260 N88PYSegler Max D · Shoreview, MNBuilt 1960 · S/N 18-7425 N88RFGrant Joseph P · Priest River, IDBuilt 1975 · S/N 18-7609027 N8900DRay Robert L · Palmer, AKBuilt 1958 · S/N 22-6055 N89018Robinson Eric · Palmer, AKBuilt 1954 · S/N 18-3583 N8901DLeberman Odin F · Santa Maria, CABuilt 1958 · S/N 22-6056 N8902DTurkington Ryan · Homer, AKBuilt 1958 · S/N 22-6057 N8902LIllini Glider Club · Danville, ILBuilt 1971 · S/N 25-5363 N8902YBraaten Allan C · Surprise, AZBuilt 1973 · S/N 18-7409032 N8903DBesner Eugene F · Hemlock, MIS/N 22-6058 N8903LPlane Fun Inc Tr Trustee · Snellville, GABuilt 1971 · S/N 25-5364 N8904CClausen Robert G · Argyle, MNBuilt 1953 · S/N 22-1498 N8904DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6059 N8904PMeline Marilyn Robinson · Stanton, MNBuilt 1966 · S/N 18-8406 N8905CHowell Aviation LLC · Orlando, FLS/N 22-1499 N8907CGrizzly Skins Of Alaska Inc · Wasilla, AKBuilt 1953 · S/N 22-1502 N8907YKiehl Dwane K · Winnett, MTBuilt 1973 · S/N 18-7409034 N8909DWellborn Michael A · Kenai, AKBuilt 1958 · S/N 22-6064 N8910CBurns Edward D · Zillah, WABuilt 1953 · S/N 22-1506 N8910DArmes John W · Elkhorn, WIS/N 22-6066 N8911CKing Michael A · Eddyville, IABuilt 1953 · S/N 22-1520 N8911DPunt Eric · Wasilla, AKBuilt 1958 · S/N 22-6067 N8912DParris Michael D · Rockport, TXFirst renewal noticeS/N 22-6068 N8913CGuess Gerald B · Hernando, FLBuilt 1953 · S/N 22-1512 N8913DBrick H Paul · Pomerene, AZBuilt 1958 · S/N 22-6069 N8914DPieper Michael D · Chandler, OKBuilt 1958 · S/N 22-6097 N8916YMyers Randall · Parshall, NDBuilt 1973 · S/N 18-7409035 N8918DPapalote Ranches LLC · Missoula, MTBuilt 1958 · S/N 22-6075 N8918YFerucci Paul G · Anchorage, AKBuilt 1973 · S/N 18-7409036 N8919CMissionary Flight Training Inc · Hobe Sound, FLS/N 22-1517 N8919DLuallin Randy D · Hot Springs, SDBuilt 1958 · S/N 22-6076 N8920DReese Larry H · Raytown, MOS/N 22-6077 N8921DPetterson Jason G · Albert Lea, MNBuilt 1958 · S/N 22-6078 N8922DHassell Clark R · Ketchikan, AKBuilt 1958 · S/N 22-6079 N8923DWood Rhonda R · Livermore, CABuilt 1958 · S/N 22-6080 N8924CHaines Delmar W · Rolla, MOBuilt 1953 · S/N 22-1519 N8924DHickey Aero Services LLC · White Hills, AZS/N 22-6081 N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083 N8928CGiber Kristofor D · Manvel, TXBuilt 1953 · S/N 22-1521 N8929LPeters Nicholas J · Eagle River, AKBuilt 1974 · S/N 18-7409127 N8930DBeverly Lester E · Shepherd, TXS/N 22-6088 N8932DRegistration Pending · Caldwell, IDRegistration pendingBuilt 1958 · S/N 22-6090 N8932YStrohmeyer Gregory C · Wasilla, AKBuilt 1974 · S/N 18-7409042 N8933DGrandy Leland P · Rock Springs, WYS/N 22-6091 N8933LDuncan Aviation Inc · Lincoln, NEBuilt 1974 · S/N 18-7409128 N8934CHandel Patrick A · Wautoma, WIBuilt 1953 · S/N 22-1532 N8937DBrunner Steve W · Mission Viejo, CABuilt 1958 · S/N 22-6099 N8937LHood River Soaring · Hood River, ORBuilt 1971 · S/N 25-5402 N8939LWestern Carolina Ag Air Inc · Catawba, NCBuilt 1971 · S/N 25-5404 N8940CDyda Wendy · Cassopolis, MIS/N 22-1539

Back to AD 99-01-05 R1