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.

N759TNAir Charter Inc DBA · Culebra, PRBuilt 1978 · S/N 18266248 N759TPItaliano William S Jr · West Boylston, MAS/N 18266249 N759TRArnold Scott J · Xenia, OHBuilt 1978 · S/N 18266251 N759TSWinter Kevin A · Ravensdale, WABuilt 1978 · S/N 18266252 N759TTTrend Companies LLC · Phoenix, AZBuilt 1978 · S/N 18266334 N759TURobeck Troy D · Okanogan, WABuilt 1978 · S/N 18266254 N759TVJimmy Mac LLC · Sun Valley, IDBuilt 1978 · S/N 18266255 N759TYKoopman Allen W · Lake Forest Park, WABuilt 1978 · S/N 18266257 N759UCCozart Marlon R · Azle, TXBuilt 1978 · S/N 18266261 N759UHAyerstech LLC · Chetek, WIBuilt 1978 · S/N 18266266 N759UJKing Forest Ind Inc · Wentworth, NHBuilt 1978 · S/N 18266267 N759ULJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266269 N759UQPatrick William B · Newport News, VABuilt 1978 · S/N 18266273 N759URStenzel Richard J · Imperial, PABuilt 1978 · S/N 18266274 N759USFly Ab Inc · Fort Lauderdale, FLBuilt 1978 · S/N 18266275 N759UUMeyerson Sanford · Smithville, TXBuilt 1978 · S/N 18266277 N759UVChamberlain Noreen J · Douglas, WYBuilt 1978 · S/N 18266278 N759UWKaufmann Michael A · Brownsburg, INBuilt 1978 · S/N 18266279 N759VPacific Coast Aero LLC · Torrance, CAFirst renewal noticeBuilt 1978 · S/N 18266286 N759VGDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 18266289 N759VHSaguto Peter J · Ballwin, MOBuilt 1978 · S/N 18266290 N759VJMoffitt John S · San Jose, CAFirst renewal noticeBuilt 1978 · S/N 18266291 N759VMJuliet Mike Holdings LLC · Friendswood, TXBuilt 1978 · S/N 18266294 N759VNHoney Cross Farms P/S · Lafayette, LABuilt 1978 · S/N 18266295 N759VPLewis Elliott Mcmorran Vaden Ragsdale & Woodward · Little Rock, ARBuilt 1978 · S/N 18266296 N759VVHumble John A · Liberal, KSBuilt 1978 · S/N 18266302 N759VYAms Aviation LLC · South Bend, INBuilt 1978 · S/N 18266305 N759WDTootle Equipment Co Inc · Reidsville, GABuilt 1978 · S/N 18266310 N759WERegistration Pending · Cottonwood, AZRegistration pendingBuilt 1978 · S/N 18266311 N759WGFtm Falcon LLC · Arnold, MDBuilt 1978 · S/N 18266313 N759WKLee Kevin J · Dunn, NCBuilt 1978 · S/N 18266316 N759WLStolyarov Yury M · Brookline, MABuilt 1978 · S/N 18266317 N759WMJames Brent A · Royal, ARBuilt 1978 · S/N 18266318 N759WNSmith Kristopher D · Wickenburg, AZBuilt 1978 · S/N 18266319 N759WPSale Reported · Farmington, MOSale reported, pending cancellationBuilt 1978 · S/N 18266320 N759WRAlmond Kevin L · Waxahachie, TXBuilt 1974 · S/N 18263231 N759WSCottrell David J · Anchorage, AKBuilt 1978 · S/N 18266322 N759WWLeading Edge Aviation Services Inc · Missoula, MTBuilt 1978 · S/N 18266326 N759WZMario J Khoury · Pasadena, CABuilt 1978 · S/N 18266329 N759XBjorlie Paul A · Pekin, NDBuilt 1977 · S/N 18266003 N759XDRegistered aircraftBuilt 1978 · S/N 18266333 N759XFRichards Chad · Brookshire, TXBuilt 1978 · S/N 18266335 N759XKWright Andrew N · Dadeville, ALBuilt 1978 · S/N 18266339 N759XQWells Mark K · Kennett Square, PABuilt 1978 · S/N 18266344 N759XWClear Skies And Tailwinds LLC · Verona, WIBuilt 1978 · S/N 18266350 N759YBVaughan Larry S · Amarillo, TXS/N 18266355 N759YDHalifax Aviation Partners Inc · Battleboro, NCBuilt 1978 · S/N 18266357 N759YEBridger Optronics LLC · Mooresville, NCBuilt 1978 · S/N 18266358 N759YGSpringville Flying Club · Spanish Fork, UTS/N 18266360 N759YHColeman Tommy · Prosper, TXBuilt 1978 · S/N 18266361

Back to AD 87-20-03 R2