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.

N1940PBrown Gerald M · Menan, IDBuilt 1955 · S/N 22-2691 N1941CEuroaviation Inc Trustee · KematenS/N 5868 N1945PScotia Aero LLC · Fort Myers, FLS/N 22-2696 N1947AKasner Mary D · Park City, MTBuilt 1952 · S/N 18-1786 N1947PSpence Ronald J · Germantown, TNBuilt 1955 · S/N 22-2698 N1947YBitterroot Ventures LLC · Show Low, AZBuilt 1947 · S/N 12-3253 N194TNicholson Earl J · New Milton, WVBuilt 1953 · S/N 18-2308 N1950PJefferies R Wayne · Durango, COFirst renewal noticeBuilt 1955 · S/N 18-4176 N1950YCostanza Joseph Vincent · Marlton, NJBuilt 1950 · S/N 18-191 N1951PBeck Aviation LLC · Fort Myers, FLBuilt 1955 · S/N 18-4177 N1952AKirkendall Clinton I · Arlington, WAS/N 22-746 N1952PWinterton Gary S · Lindon, UTBuilt 1955 · S/N 18-4178 N1953MFugate Terry L · Atoka, OKS/N 182998 N1953NKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 11-820 N1953PCub 1953p LLC · Boise, IDBuilt 1955 · S/N 18-4180 N1953VAarestad Potato Co Ltd · Hillsboro, NDBuilt 1952 · S/N 18-2174 N1954PClark Shawn W · Anchorage, AKBuilt 1955 · S/N 18-4181 N1955PRegistration Pending · Palmer, AKRegistration pendingBuilt 1955 · S/N 18-4182 N1956PNormark Nancy B · Weirsdale, FLBuilt 1955 · S/N 18-4183 N1957ASkywagon Aero LLC · Wilmington, DEBuilt 1952 · S/N 18-1795 N1958PRush Brendon · Merritt Island, FLBuilt 1958 · S/N 22-6008 N1959AWhite B Scott · Castlewood, VAFirst renewal noticeBuilt 1952 · S/N 18-1801 N195THandyside Bryan P · Duluth, MNBuilt 1953 · S/N 18-2309 N1961AYoung Connie J · Myrtle Point, ORBuilt 1952 · S/N 20-878 N1961PWainwright Charles W · Portland, ORBuilt 1955 · S/N 18-4190 N1964SLewis Steve D · Elizabethton, TNBuilt 1963 · S/N 18-8074 N1965PWedell Andrew R · Lumberton, NJBuilt 1955 · S/N 18-4196 N1966PSos David M · Klamath Falls, ORBuilt 1955 · S/N 18-4197 N1967KAir-Ag Inc · Tarboro, NCBuilt 1947 · S/N 11-1523-201 N1968PWygant Michelle R · Copper Center, AKBuilt 1957 · S/N 18-4200 N1974PWarren Josiah E · Sterling, AKBuilt 1955 · S/N 18-4207 N1977PFischer Roger L · Copper Center, AKBuilt 1955 · S/N 18-4212 N1978AMoore Eugene K · Portsmouth, OHBuilt 1952 · S/N 22-545 N1983PCarlson Andrew J · Ashville, NYBuilt 1955 · S/N 18-4218 N1984ASuper D Group LLC · Hanoverton, OHBuilt 1952 · S/N 18-1808 N1988ABroussard Lewis A Jr · Morse, LABuilt 1952 · S/N 18-1813 N1988PMuschany Charles M · Anchorage, AKBuilt 1955 · S/N 18-4223 N198TPDonnelly Thomas E · Salome, AZBuilt 1957 · S/N 22-5625 N1991AHolman Daily A · Canby, ORBuilt 1952 · S/N 18-1815 N1994AHuppert Gerald P · Palmer, AKBuilt 1952 · S/N 18-1816 N1996ADidisse Robert T · Mccall, IDBuilt 1953 · S/N 22-1092 N1999PByler Dennis E · Wasilla, AKBuilt 1955 · S/N 22-2710 N199WYJohnston Dwight D · Rawlins, WYBuilt 1978 · S/N 18-7809075 N19FNFranzen Chase M · San Diego, CABuilt 1959 · S/N 22-6906 N19GBClark Timothy A · Fairbanks, AKBuilt 1961 · S/N 18-7666 N19JCCarney Jerald C · Boise, IDBuilt 1958 · S/N 22-6320 N19MYCamino Thomas J · Buffalo, WYBuilt 1946 · S/N 12-2274 N19SJTurner Christian M · Eastsound, WABuilt 1952 · S/N 22-596 N1JLMeggers Roger D · Baker, MTBuilt 1974 · S/N 18-7409100 N1KZZiesmer Katherine · University Place, WAS/N 18-6440

Back to AD 99-01-05 R1