Skip to content

Registered aircraft · 54,015

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

N734UMSweet Sunshine Produce Co LLC · Ocala, FLBuilt 1977 · S/N 17269125 N734UPLee Randall Ross · Houston, TXS/N 17269127 N734UQFuture Technologies Inc · Colonia, NJBuilt 1977 · S/N 17269128 N734URKastle Todd Trustee · Gilroy, CAS/N 17269129 N734USLowery Dwight W · Clayton, NCBuilt 1977 · S/N 17269130 N734UTBlue Sky Aviation LLC · Menominee, MIBuilt 1977 · S/N 17269131 N734UUPenn Aero LLC · Lewisburg, PABuilt 1977 · S/N 17269132 N734UVCavu Flying Club · Wauwatosa, WIBuilt 1977 · S/N 17269133 N734UWFisher Stephen C Trustee · Lamar, ARS/N 17269134 N734UXJantz Carl R · Columbia, MOBuilt 1977 · S/N 17269135 N734UYAg & Csv Inc · Pine Bush, NYBuilt 1977 · S/N 17269136 N734UZDream Unthreatened LLC · San Luis Obispo, CABuilt 1977 · S/N 17269137 N734VCNashville Skyscrapers LLC · Old Hickory, TNBuilt 1977 · S/N 17269140 N734VEFlyby Aviation LLC · Logan, UTBuilt 1977 · S/N 17269142 N734VNKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 17269150 N734VPBooth Danielle M · Somis, CABuilt 1977 · S/N 17269151 N734VQJprg Aviation Inc · Orlando, FLBuilt 1977 · S/N 17269152 N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614 N734VTDestination Aviation LLC · Destin, FLBuilt 1977 · S/N 17269155 N734VVSummit Flight Services LLC · Paden, OKBuilt 1977 · S/N 17269157 N734VXRed Door Aviation LLC · Dover, DEBuilt 1977 · S/N 17269159 N734VZTri Air Inc · Aulander, NCBuilt 1977 · S/N 17269161 N734WBWedoaero LLC · Vale, NCS/N 17269163 N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883 N734WFLewis Patrick K · El Dorado, ARS/N 17269167 N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615 N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616 N734WKWagner James M · Hockessin, DEBuilt 1977 · S/N 17269171 N734WLFlight Answers LLC · Miami Lakes, FLS/N 17269172 N734WNBoerne Flight Options LLC · Boerne, TXBuilt 1977 · S/N 17269174 N734WPLaps LLC · Elkhorn, WIBuilt 1977 · S/N 17269175 N734WRSealy Michael Robert · Summerville, SCBuilt 1977 · S/N 17269177 N734WSWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269178 N734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1979 · S/N U20604886 N734WZTingman Christopher · Seattle, WABuilt 1977 · S/N 17269185 N734XCCurrier William R · Ormond Beach, FLBuilt 1977 · S/N 17269188 N734XDByrne David · Three Rivers, MIBuilt 1977 · S/N 17269189 N734XHFlyright Aviation Inc · North Las Vegas, NVS/N 17269193 N734XKEllig Todd L · Horace, NDBuilt 1977 · S/N 17269195 N734XLWalsh Patrick Sean · Osterville, MABuilt 1977 · S/N 17269196 N734XMTri Star Cac LLC · Plano, TXBuilt 1977 · S/N 17269197 N734XPDutcher John A · Cedar Falls, IAS/N 17269199 N734XQSumter County Sheriffs Office · Sumter, SCBuilt 1977 · S/N 17269200 N734XRWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269201 N734XSCrabtree Clifford I · Ukiah, CABuilt 1977 · S/N 17269202 N734XTFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N 17269203 N734XXHuerta Holdings Inc · Santa Ana, CABuilt 1977 · S/N 17269207 N734XYBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269208 N734YALuxair LLC · College Station, TXBuilt 1977 · S/N 17269210 N734YBHrbk LLC · Grandview, INBuilt 1977 · S/N 17269211

Back to AD 87-20-03 R2