Skip to content

Registered aircraft · 3,193

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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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:77-13-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
  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:77-13-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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.

N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054 N6923PLopez Ruben Arellano · Nogales, AZS/N 24-2057 N6924PLauderback Lee L · Fort Collins, COBuilt 1960 · S/N 24-2058 N6928POwen Colin Jc · College Station, TXBuilt 1960 · S/N 24-2062 N6932PMartenson Matthew J · Elgin, SCBuilt 1960 · S/N 24-2066 N6933PGeorghiou Sophia B · San Diego, CABuilt 1960 · S/N 24-2067 N6934PChapman William R · Monroe, GABuilt 1960 · S/N 24-2068 N6938PSpero Robert C · Kent, WABuilt 1960 · S/N 24-2072 N6942PPikes Peak Fliers At Meadowlake Airport LLC · Colorado Springs, COFirst renewal noticeBuilt 1960 · S/N 24-2077 N6947PHudzinski Joel David · Newaygo, MIBuilt 1960 · S/N 24-2082 N6948PBernard David J · Paris, OHS/N 24-2083 N6949PDepew Kevin I · Everett, WABuilt 1960 · S/N 24-2084 N694APCook Christopher W · Indian Mound, TNS/N 24-1147 N6950PRegistered aircraftBuilt 1960 · S/N 24-2085 N6951PRossback Jason M · Denver, COBuilt 1960 · S/N 24-2086 N6952PBretts Flying Service LLC · Mount Pleasant, MIS/N 24-2087 N6953PCianciolo Philip H · Yakima, WABuilt 1961 · S/N 24-2088 N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090 N6959PSteamboat Express LLC · Sheridan, WYBuilt 1960 · S/N 24-2097 N6962PSteyn Glen D · Marietta, OHBuilt 1960 · S/N 24-2100 N6964PEvans Phillip R · Dinuba, CABuilt 1960 · S/N 24-2104 N6968PFoos LLC · Vancouver, WABuilt 1960 · S/N 24-2109 N6969PHart Richard W · Alexandria, VABuilt 1960 · S/N 24-2111 N696PGreer James E Jr · Summit Point, WVBuilt 1960 · S/N 24-1718 N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116 N6978PGallego Victor · Matawan, NJBuilt 1960 · S/N 24-2121 N6981PShakis Bear LLC · O Neill, NEBuilt 1960 · S/N 24-2124 N6982PCapuano Group Inc · Ormond Beach, FLBuilt 1960 · S/N 24-2125 N6983PRegistration Pending · Branchburg, NJRegistration pendingBuilt 1960 · S/N 24-2126 N6984PEnglish John H · Pittsburg, TXBuilt 1960 · S/N 24-2127 N6985PDull Stephen A · Redkey, INBuilt 1960 · S/N 24-2128 N6988PKubitz Wesley M · Laurel, MTBuilt 1960 · S/N 24-2131 N6994PHunt Ray A · Louisburg, NCBuilt 1960 · S/N 24-2137 N6995PInternational Air Services Inc Trustee · Carson City, NVBuilt 1960 · S/N PA-24-2138 N6996PWelling Charles E III · West Islip, NYBuilt 1960 · S/N 24-2139 N69PDDemray William S · Northville, MIBuilt 1960 · S/N 24-1377 N69RDKrens Janet E · Purcellville, VABuilt 1963 · S/N 30-183 N6YLHolman Leasing LLC · Anchorage, AKS/N 301162 N6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 30-572 N7000YSlowpoke Air LLC · Palm Harbor, FLBuilt 1966 · S/N 30-1188 N7001PPavlusik Tibor · Fort Mill, SCS/N 24-2146 N7002PMonterey Bay Aviation Inc · Watsonville, CABuilt 1960 · S/N 24-2147 N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148 N7007PAden Charles L · Hudson, COBuilt 1960 · S/N 24-2151 N7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLBuilt 1963 · S/N 30-9 N700KRStrange Jim · Tyler, TXBuilt 1963 · S/N 30-52 N7010PJuliett Tango LLC · West Rutland, VTBuilt 1960 · S/N 24-2154 N7010YBrown William C Jr · Northville, MIBuilt 1963 · S/N 30-11 N7011PJapikse Bert · Pawleys Island, SCBuilt 1960 · S/N 24-2156 N7012YBooher Greg F · Livingston, TNBuilt 1963 · S/N 30-13

Back to AD 77-13-21