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.

N2322AMertens Darrel W · Sterling, COBuilt 1952 · S/N 18-1898 N2322MJohnson Walter H · White Stone, VABuilt 1946 · S/N 12-1482 N2322PWilliams John P · Lisbon, OHS/N 22-2733 N2323PMertens Michael R · Denton, NEBuilt 1955 · S/N 22-2734 N23245Pike John P · Oregon City, ORBuilt 1939 · S/N 3013 N2324MLeonard Stephen P · Anchorage, AKBuilt 1946 · S/N 12-1488 N23252Ttnh LLC · Wilmington, DEBuilt 1939 · S/N 3016 N23255Griebsch James J · Saranac Lake, NYBuilt 1939 · S/N 4569 N2325AReece Andy · Marysville, WAS/N 18-1901 N2325MSharp Frank J DBA · Windermere, FLBuilt 1946 · S/N 12-1491 N2325PCarnahan Thomas L · Wasilla, AKS/N 22-2736 N23267Scherbon Scott W Sr · Amesbury, MAS/N 3033 N2326MNapoleon Christopher D · Allegany, NYBuilt 1946 · S/N 12-1490 N2327MPence Dale E · Richmond, MOBuilt 1946 · S/N 12-1390 N2327PRoa Rembrandt Aguspina · Anchorage, AKBuilt 1955 · S/N 22-2738 N2328MDraveliing Larry J · Wasilla, AKBuilt 1946 · S/N 12-1483 N2329MWard Doran L · Glennallen, AKBuilt 1946 · S/N 12-1391 N232MMeredith Dean J · Boynton Beach, FLBuilt 1955 · S/N 184122 N232PBBrandt Terry R · Hood River, ORS/N 3011 N232WWells Garry L · Scotia, NEBuilt 1946 · S/N 12-701 N2330AAllen Christopher S · Aberdeen, SDS/N 22-708 N2330MSquiers Jeffrey S · Independence, MNS/N 12-1393 N23326Russell Michael K · Sprakers, NYBuilt 1939 · S/N 4-585 N2332AStauffer Michael S · Wichita Falls, TXBuilt 1952 · S/N 22-709 N2333HHolseberg Aviation LLC · Ridgeville, SCBuilt 1979 · S/N 18-7909171 N23345Faulkner Ronnie L · Royal, ARBuilt 1939 · S/N 3089 N2334HFff Air LLC · Ashland, OHBuilt 1979 · S/N 18-7909172 N2335PGrosse Martin · Viola, WIBuilt 1955 · S/N 22-2746 N2337AHrutkay Charles S · Scenery Hill, PAS/N 20-917 N2339PMulvania Rodney A · Linn, MOBuilt 1955 · S/N 22-2750 N23409Miller Harrison · Hallsville, MOS/N 3144 N2340SWhalen Patrick M · Anchorage, AKBuilt 1979 · S/N 18-7909134 N23410Dyrstad Mary S · Hampshire, ILBuilt 1966 · S/N 3142 N23417Komrowski Ronald H · Jupiter, FLBuilt 1939 · S/N 4-611 N2341MMarcum Raymond A · Anchorage, AKS/N 12-1604 N2342AThomas Todd · Sandy Hook, MSBuilt 1952 · S/N 22-732 N2342MSteens Mountain Packers · Frenchglen, ORBuilt 1946 · S/N 12-1605 N2343HAerobinninger LLC · Mccall, IDBuilt 1979 · S/N 18-7909173 N2343PStalder Fredrick Bleu · Magnolia, TXBuilt 1955 · S/N 22-2754 N2344AYoung Carl J · Lubbock, TXS/N 22-718 N2344MHershey Eric F · Wasilla, AKBuilt 1946 · S/N 12-1485 N2344PVieaux James M · Park Forest, ILBuilt 1955 · S/N 22-2755 N2346MHendrickson Gary A DBA · Gold Beach, ORS/N 12-1609 N2348MSurgent Richard L · Wall Township, NJBuilt 1947 · S/N 12-1607 N2349MMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 12-1494 N234TDelia Patrick S · Palmer, AKBuilt 1953 · S/N 18-2348 N2350ABarlow Kirk A · Eads, COBuilt 1952 · S/N 22-725 N2353XB R Trucking LLC · Cut Bank, MTBuilt 1956 · S/N 18-4239 N2354ANelson David R · New Richmond, WIS/N 22-724 N2355HJohnson Scott · Wasilla, AKBuilt 1979 · S/N 18-7909175

Back to AD 99-01-05 R1