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.

N913APeckenpaugh Dawson S · Worden, MTBuilt 1951 · S/N 22-219 N9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529 N9141DEdburg Stan · Mead, WABuilt 1958 · S/N 18-6530 N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533 N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002 N9145DMastre Ben T · Soldotna, AKS/N 18-6535 N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536 N9147DRiggin Flight Service Inc · Madison, SDBuilt 1958 · S/N 18-6537 N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540 N91523Givens Eric J · Frankfort, OHBuilt 1947 · S/N 11-368 N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207 N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208 N9158YLockwood Rick I · Garden Grove, CAS/N 18-8911 N915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeBuilt 1951 · S/N 22-218 N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212 N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216 N9165DNelson Vanessa Jump Trustee · Portland, ORBuilt 1958 · S/N 22-6218 N9166TBoling Scott D · Idaho Falls, IDBuilt 1979 · S/N 18-7909065 N9167TEyes Above LLC · Hampton Falls, NHS/N 18-8009011 N9169DLapaseotes George P II · Sidney, NEBuilt 1958 · S/N 22-6222 N9169THayes George F · Friendsville, PABuilt 1979 · S/N 18-8009012 N916TMMo Properties & Investments LLC · Lakewood, COBuilt 1994 · S/N 1809101 N916YEggimann William W Trustee · Anchorage, AKBuilt 1973 · S/N 18-7309023 N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224 N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226 N9174HBarf Aviation LLC · Huntsville, ALBuilt 1946 · S/N 12-288 N9174TPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009013 N9176DSmaha Daniel B · Glide, ORBuilt 1958 · S/N 22-6233 N9177DCheyann Jordan · Coupeville, WABuilt 1958 · S/N 22-6234 N917BSPalmer Ryan L · Waynesville, OHBuilt 1952 · S/N 18-2009 N917ESStukenholtz William W · Lincoln, NEBuilt 1952 · S/N 18-2026 N917VKNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1974 · S/N 18-7409056 N9182TShortridge Randall R · Mesa, AZBuilt 1978 · S/N 25-7856026 N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244 N9188TArizona Soaring Inc · Maricopa, AZBuilt 1978 · S/N 25-7856039 N9189DBinggeli Mark A · Wasilla, AKS/N 186528 N9189TBunselmeier Donald W · Delta Junction, AKBuilt 1979 · S/N 18-8009020 N918EDFlying R Partnership · Huntsville, UTBuilt 1977 · S/N 18-7809007 N918TFRegistration Pending · Portland, ORRegistration pendingBuilt 1947 · S/N 12-2232 N91906Martin Jonathan B · Alamogordo, NMS/N 12-15 N91908Hollingsworth Lloyd Dan · Anchorage, AKBuilt 1946 · S/N 12-17 N91911Messinger Donald E · Wasilla, AKS/N 12-20 N91913Gunter Honey Inc · Towner, NDS/N 11-1 N9192DHadley Sheldon L · Hope, ARS/N 22-6251 N9193ZThacker William E · Chenoa, ILBuilt 1953 · S/N 18-2641 N91943Clark Henry F Jr · Fort Edward, NYBuilt 1946 · S/N 16363 N9194DDaniels Daryl A · Warren, OHBuilt 1958 · S/N 22-6253 N919ASchulze Thomas A · Bloomville, OHBuilt 1951 · S/N 22-223 N92044Lear Eric T · Tomahawk, WIBuilt 1946 · S/N 16477 N9205DHayden Scott D · Anchorage, AKBuilt 1958 · S/N 22-6264

Back to AD 99-01-05 R1