Skip to content

Registered aircraft · 20,481

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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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.

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 N759WEMinch Lawrence J · Cottonwood, AZBuilt 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 N759YMJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266365 N759YQPreston Dan R · Medway, MABuilt 1978 · S/N 18266368 N759YRDoss Michael G · Austin, TXBuilt 1978 · S/N 18266369 N759YSBowers LLC · Englewood, COBuilt 1978 · S/N 18266370 N759YURegistered aircraftBuilt 1978 · S/N 18266372

Back to AD 84-10-01 R1