Skip to content

Registered aircraft · 18,497

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

N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392 N73067Grant Aviation Inc · Anchorage, AKBuilt 1979 · S/N 20700558 N7307QN7307q LLC · Wickenburg, AZBuilt 1978 · S/N 18503600 N7309VGray Ronald Wayne · Hooker, OKBuilt 1968 · S/N 30176 N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853 N730CN730c LLC · Merrimack, NHS/N 0410 N73100Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 20700559 N7310VBell Richard J · Cuba, MOS/N 30165 N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561 N7313VRegistered aircraftBuilt 1969 · S/N 30166 N7315RMitchell Michael · Prattville, ALBuilt 1974 · S/N E-558 N7315VSouthern Union State Community College · Opelika, ALBuilt 1969 · S/N 30164 N7316UDarvek LLC · Las Vegas, NVBuilt 1965 · S/N 411-0016 N7316VSimmones James M · Moriarty, NMS/N 30171 N7318HMichaud Francis G · Marine St Crx, MNBuilt 1977 · S/N 18503359 N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735T N731ATMark L Carman · Aiken, SCBuilt 2005 · S/N 1728 N731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763T N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437 N731BMBenaiah Holdings Corp · Marion, KYS/N 18802768T N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545 N731CDOwen Brian F · Tulsa, OKBuilt 2001 · S/N 0129 N731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785T N731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794T N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442 N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446 N731EMAuer William W · Saint Petersburg, FLBuilt 1988 · S/N E-2446 N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843T N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450 N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452 N731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862T N731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864T N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454 N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457 N731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877T N731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887T N731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891T N731GVSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N EA-631 N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464 N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465 N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468 N731JAMccallister Aviation Rentals & Sales LLC · Qulin, MOBuilt 1998 · S/N TH-1884 N731JGGate Air LLC · Ketchum, IDBuilt 1980 · S/N P21000474 N731JXKai Herbert DBA · Rillito, AZFirst renewal noticeS/N P21000479 N731KLMullen James P Jr · Rogers, ARS/N P21000483 N731KWVann Dudley C DBA · Greenville, NCBuilt 1977 · S/N 18802963T N731LACmk Aerial Inc · Sutton, NEBuilt 1977 · S/N 18802967T N731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WABuilt 1980 · S/N P21000488 N731LTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N P21000436 N731LUDiversified Air LLC · Kalispell, MTBuilt 1980 · S/N P21000490

Back to AD 86-13-04 R3