Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N629CDrc Aviation Of Stuart LLC · Palm City, FLBuilt 2003 · S/N 3257331 N629DKUnited Steel Erectors Corp · Atlantic, IABuilt 1998 · S/N 4636158 N629RMW J Halberstadt Transportation Inc · Hartland, WIBuilt 1980 · S/N 31-8052197 N62ADHawkins Flight Academy LLC · Shelbyville, TNBuilt 1973 · S/N 27-7305070 N62BPPecan Aviation LLC · Granbury, TXBuilt 1980 · S/N 32-8024041 N62CASchoenle Paul D · South Bend, INBuilt 1996 · S/N 4636025 N62GWGoshen Wings Inc · Bristol, INBuilt 1980 · S/N 32R-8129030 N62LLAirborne Research LLC · Fort Pierce, FLBuilt 1961 · S/N 500A-1122-58 N6300MShortfin Holdings LLC · Seneca, SCBuilt 1974 · S/N 32-7440141 N6300YSullivan Mark F · Cocoa Beach, FLFirst renewal noticeBuilt 1974 · S/N 32-7540044 N630KCCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-997-28 N6312SLadies Leasing LLC · Steamboat Springs, COBuilt 2004 · S/N T18208297 N6321YHallstein Roy M · San Jose, CAS/N 27-3578 N6334YHofer Perry L · Doland, SDBuilt 1966 · S/N 27-3596 N633SGCherokee N633sg LLC · Leonardtown, MDBuilt 1972 · S/N 32-7340051 N633WSGilmores Glorious Goods LLC · Lewes, DEBuilt 1965 · S/N 27-2887 N634CTCorsair Aviation LLC · Yuba City, CABuilt 1972 · S/N 3121 N6353YAlpine Aviation LLC · Oasis, IDBuilt 1967 · S/N 27-3620 N635BDLumpkin William Jeffrey · Fishers, INBuilt 1976 · S/N 32R-7680233 N635RRobertello Gerald W · Centreville, VABuilt 1955 · S/N 35092 N63693Budd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 31-7712025 N6369USpecialty Aero Services LLC · Bayside, WIBuilt 1964 · S/N 1465-165 N6370YWaskow Lawrence · Neenah, WIBuilt 1967 · S/N 27-3645 N63759Mintari Robert E · Hartland, MIS/N 27-7754092 N6375YChurch Of Bible Understanding · Scranton, PABuilt 1967 · S/N 27-3654 N63790Mcphillips Flying Service Inc · Beaver Island, MIBuilt 1977 · S/N 27-7754117 N637TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 27-7754095 N63862Deltafox Aviation LLC · Port Orange, FLBuilt 1977 · S/N 27-7854014 N63877N63877 Inc · Lewes, DEBuilt 1977 · S/N 27-7854026 N63885Farrar Mark W · Cocoa, FLS/N 27-7854030 N63886Red State LLC · Daytona Beach, FLBuilt 1977 · S/N 27-7854031 N63895American Drilling Of Alabama Inc · Alabaster, ALBuilt 1977 · S/N 27-7854039 N638RJEuroaviation Inc Trustee · KematenBuilt 1997 · S/N 27-0231 N6393YPage Ronald D · Walla Walla, WABuilt 1967 · S/N 27-3680 N63951Antonov Aero LLC · Austin, TXBuilt 1978 · S/N 27-7854083 N63965Kp Aviation Solutions LLC · Romeoville, ILBuilt 1978 · S/N 27-7854095 N63AJSehgal Aviation Inc · Shoreline, WABuilt 2003 · S/N 3255003 N63BTSilverback Solutions LLC · Amlin, OHBuilt 1976 · S/N 32R-7680094 N63FM63 Foxmike Inc · Wilmington, DEBuilt 1999 · S/N 27-0274 N63LTGlobal Green Initatives LLC · Houston, TXS/N 27-7754100 N6401YBudd Richard E · Brooksville, FLBuilt 1967 · S/N 27-3686 N6404YUphold Thomas R · Arlington, TXBuilt 1968 · S/N 27-3897 N640BDEdair LLC · Newport, RIBuilt 1990 · S/N 4622095 N640GCComanche 640gc LLC · Henderson, NVS/N 24-4890 N6416YMcm Aviation LLC · Estero, FLBuilt 1967 · S/N 27-3708 N6418YWalker Gilbert R · Brentwood, TNBuilt 1967 · S/N 27-3710 N642JF6 Xt LLC · Fort Lauderdale, FLBuilt 2005 · S/N 3255040 N642WAGunnslinger Air LLC · Destin, FLBuilt 1979 · S/N 31-7952084 N6430YFord William E · Minnetonka, MNBuilt 1967 · S/N 27-3728 N644BCRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1976 · S/N 32R-7680229

Back to AD 84-19-03 R1