Registered aircraft · 29

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

N103NJUsda Forest Service Fepp · Trenton, NJBuilt 1969 · S/N 361 N106ZZBrown Helicopter Inc · Pensacola, FLBuilt 1970 · S/N 508 N121BT206 Holdings LLC · Spanish Fork, UTS/N 395 N123NCNorth Carolina State Highway Patrol · Cary, NCBuilt 1971 · S/N 610 N123RJR J Corman Railroad Co/Bardstown Line · Nicholasville, KYBuilt 1968 · S/N 148 N1368XLinscott Jeffrey R · Boring, ORBuilt 1967 · S/N 7 N1431WC-Pan Aero LLC · Stratford, CTBuilt 1969 · S/N 374 N204AVSan Juan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 158 N206KRHandy Air Inc · Douglas, GABuilt 1969 · S/N 437 N206WCRuckle Kelby J · Whittemore, MIBuilt 1969 · S/N 345 N206YYMshr Helicopter Service LLC · Chehalis, WABuilt 1968 · S/N 132 N2239WBodner Jessica Kay · Emigrant, MTBuilt 1969 · S/N 461 N321AWBolin William E · Smithville, OHBuilt 1967 · S/N 82 N392MUsda Forest Service Fepp · Helena, MTBuilt 1969 · S/N 362 N4013GRegistered aircraftS/N 171 N4042GKlein Flying Service Inc · Lawrenceville, ILS/N 242 N4067GDiamond Helicopters LLC · Los Angeles, CABuilt 1968 · S/N 226 N504EHWest Valley Aviation Inc · Five Points, CABuilt 1967 · S/N 19 N555SJApex59 LLC · Saint Paul, MNBuilt 1968 · S/N 308 N5869YMid South Aviation Institute · Black Rock, ARBuilt 1971 · S/N 44001 N7161JGlobal Overhaul Inc · Lafayette, LAS/N 135 N72365Glacier Aviation Inc · Olympia, WABuilt 1972 · S/N 44061 N7242USl Jet H LLC · Franklin, NCBuilt 1972 · S/N 44038 N7963JSan Juan Aviation LLC · Wilmington, DEBuilt 1971 · S/N 685 N8136TEdgefield Aviation LLC · Sandy, ORBuilt 1972 · S/N 72-21213 N8155JAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1970 · S/N 547 N863LAEngage Helicopters LLC · Sarasota, FLBuilt 1968 · S/N 68-16904 N911AFMarion County Sheriffs Office · Ocala, FLS/N 72-21347 N922MCGeco Inc · Wilmington, DEBuilt 1970 · S/N 68-16829

Back to AD 71-08-03