Skip to content

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.

N28104Aubin Carol M · Bangs, TXS/N 5-107 N28107Cross Mark J · Nokesville, VABuilt 1940 · S/N 4583 N2810MDavis Ronald L Jr · Soldotna, AKBuilt 1946 · S/N 12-1263 N28118Nightingale Patrick R · Lakewood, CABuilt 1940 · S/N 4594 N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804 N28123Webster Bart · Rexburg, IDBuilt 1940 · S/N 5-109 N28124Schelde Brian L · Marble Falls, TXBuilt 1940 · S/N 5-110 N28125N28125 LLC · Wilmington, DEBuilt 1940 · S/N 5-111 N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805 N28132Hesse Roy A · Stacy, MNS/N 4606 N28143Powell Kenneth W · Ann Arbor, MIBuilt 1940 · S/N 5-116 N28144Maloy Toby · Albuquerque, NMS/N 5-117 N28146Young James W · Talking Rock, GABuilt 1940 · S/N 4611 N28148North Central Marketing Inc · Cranston, RIBuilt 1940 · S/N 4615 N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182 N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807 N28151Stewart Thomas · Churchville, NYBuilt 1940 · S/N 5-119 N28153Dance Brett A · Bentonville, ARBuilt 1940 · S/N 5-124 N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108 N28161Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1940 · S/N 5-122 N28162Farris Timothy M · Raleigh, NCBuilt 1940 · S/N 4623 N28180Copithorne Richard J · West Paris, MEBuilt 1940 · S/N 5-131 N2818PHancock Timothy R · Malinta, OHBuilt 1955 · S/N 22-3111 N2818ZJohnston Charles W C · Newfield, NJS/N 22-6811 N2819MDzr Enterprises LLC · Missoula, MTBuilt 1946 · S/N 12-1174 N2819PRector David F · Akron, OHBuilt 1955 · S/N 22-3112 N28209Shea Timothy M · Pearland, TXBuilt 1940 · S/N 4-1135 N2820MFlynt Gary J · Baytown, TXBuilt 1946 · S/N 12-1172 N2821MPacker Louis M · Wasilla, AKBuilt 1946 · S/N 12-1171 N2821ZLarson Sidner J · Tucson, AZBuilt 1959 · S/N 22-6826 N28232Woodstock Pilots Club Inc · Linville, VABuilt 1940 · S/N 4-1154 N28233Riley Glenn R · Mexico, MOBuilt 1952 · S/N 4-1156 N2823MFedorka Paul R Trustee · Soldotna, AKBuilt 1946 · S/N 12-1409 N2823ZKennedy Richard A · Livonia, MIBuilt 1959 · S/N 22-6817 N28245Howe Norman E · Wausau, WIBuilt 1940 · S/N 5-164 N28248Potter Paul · Lopez Island, WABuilt 1940 · S/N 5-156 N28253Beezhold Terence J · Lake Stevens, WABuilt 1940 · S/N 4650 N2825ZBraxling Todd A · Soldotna, AKBuilt 1959 · S/N 22-6819 N28273Hicks Joseph O · Germanton, NCBuilt 1940 · S/N 4664 N2827MAdams James M · Pontiac, ILBuilt 1946 · S/N 12-1306 N28281Bc And B LLC · Lino Lakes, MNBuilt 1940 · S/N 4670 N2828PWood Levi S · Anchorage, AKBuilt 1955 · S/N 22-3121 N2828ZWalters Thomas M · Lyman, WYBuilt 1959 · S/N 22-6823 N2829MAlaska Media LLC · Anchorage, AKBuilt 1946 · S/N 12-1266 N282KZShawver Aviation LLC · Knoxville, IABuilt 1978 · S/N 18-7809091 N2830MMullins Esten R · El Paso, TXS/N 12-1267 N2833ZVaughn James F · La Porte, INS/N 22-6828 N2834PStevens Constance I · Homewood, CABuilt 1955 · S/N 22-3127 N2836MSwihart Matthew S · Hood River, ORBuilt 1946 · S/N 12-1273 N2836PWells Michael D · Wilton, MEBuilt 1955 · S/N 22-3133

Back to AD 99-01-05 R1