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.

N731MJLake Chelan Helicopters LLC · Manson, WABuilt 1974 · S/N U20602362 N731MLRomine George · Sahuarita, AZS/N D-10208 N731MQClassic Management Corp · Marion, INBuilt 1980 · S/N P21000496 N731NCSmith Bryan · Wenatchee, WABuilt 1980 · S/N P21000502 N731NRWife Approved LLC · Torrance, CABuilt 1980 · S/N P21000509 N731NUNgu Services LLC · Sheridan, WYBuilt 1980 · S/N P21000512 N731NXCarey Richard · Dallas, TXBuilt 1980 · S/N P21000515 N731NZWoodgrain Millwork Transportation LLC · Fruitland, IDBuilt 1980 · S/N P21000517 N731PCapital Dental Management · Medford, ORBuilt 2001 · S/N TH-1997 N731PDInvisible Angels · Washington, DCBuilt 1980 · S/N P21000519 N731PHTorkelson Charles A · San Antonio, TXBuilt 1977 · S/N 18803044T N731PJBreckenridge Interests Ltd · Corpus Christi, TXBuilt 1980 · S/N P21000523 N731PMAir Ag Inc · Tarboro, NCBuilt 1977 · S/N 18803048 N731QCTim Whitfield Aviation · Fairfield, NCBuilt 1977 · S/N 18803063T N731QGMowbray Jerry H · Reno, NVBuilt 1980 · S/N P21000525 N731QHK17 Corp · Alamosa, COBuilt 1980 · S/N P21000526 N731QNOkeeffe William Trustee · San Francisco, CABuilt 1980 · S/N P21000529 N731QRAir Rosa LLC · Tupelo, MSBuilt 1980 · S/N P21000531 N731RRAviation Inventions LLC · Windsor, COBuilt 1980 · S/N P21000538 N731RWAdvanced Products Sales LLC · Tempe, AZBuilt 1980 · S/N P21000540 N731SSale Reported · Phoenix, AZSale reported, canceledBuilt 1968 · S/N TE-541 N731SCMoore Scott A · Longview, TXBuilt 1980 · S/N P21000543 N731TBEastern Flying Service Inc · Middletown, DEBuilt 1978 · S/N 18803133 N731TPHangar 28 LLC · Littleton, COBuilt 1980 · S/N P21000546 N731TQSnider Scott E DBA · Turner, MTS/N 18803146T N731TSSantana Hector Rafael · Crystal River, FLBuilt 1978 · S/N 18803148T N731UFPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803160T N731VXGoff Bayou LLC · Shelby, MSBuilt 1978 · S/N 18803200T N731VYCarr Scott A · Allen, NEBuilt 1978 · S/N 18803201T N731WCCross Wayne Trustee · Novato, CABuilt 2001 · S/N E-3404 N731WVKutschera Theodore C DBA · Callicoon, NYBuilt 1978 · S/N 18803222T N731XNPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803239T N731XXGrimm John H II · Driftwood, TXBuilt 1980 · S/N P21000559 N731YRAbernathy Larry D · Tipton, OKBuilt 1978 · S/N 18803266 N731ZBVanderwaal Shane J · Junction City, WIBuilt 1980 · S/N P21000565 N731ZFTuggle James L Jr · Scottsdale, AZBuilt 1980 · S/N P21000566 N7320GDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N U20603763 N7320HAlaska Trophy Safaris Inc · Chugiak, AKBuilt 1977 · S/N 18503360 N7320UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700397 N73217Ryan Air Inc · Anchorage, AKBuilt 1979 · S/N 20700572 N7322VKem Bobby G · Muscatine, IABuilt 1968 · S/N 30177 N73266Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 20700574 N7327VHall Lee Eric · Lonoke, ARFirst renewal noticeBuilt 1969 · S/N 30182 N732ADDavis Billy E · Castlewood, SDBuilt 1976 · S/N 21061355 N732AQGold Star Air · Portland, MEBuilt 1976 · S/N 21061366 N732AVRomberg Wayne Dennis · Forked River, NJBuilt 1976 · S/N 21061371 N732AXAnimal Hospital Of Fayetteville Pa · Fayetteville, NCS/N 21061373 N732BASparks Steve · Hamilton, OHBuilt 1976 · S/N 21061376 N732BBBishop Thomas W · Decatur, TXBuilt 1976 · S/N 21061377 N732BHSeven Eagles Aviation Lc · Gainesville, FLBuilt 1976 · S/N 21061383

Back to AD 86-13-04 R3