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.

N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945 N47PHReal Time Aviation LLC · Southlake, TXBuilt 2016 · S/N TH-2467 N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142 N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176 N47SRRendezvous T82 LLC · Mansfield, TXS/N 1418 N47TCWright Frank David · Sequin, TXBuilt 1975 · S/N 21061028 N47TLObendorf Phillip G · Parma, IDBuilt 1976 · S/N 18503185 N47WK57 Bw LLC · Reno, NVBuilt 2007 · S/N TH-2179 N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217 N47WWLake Shore Aircraft Holdings LLC · Wurtsboro, NYBuilt 2011 · S/N E-3963 N4801PMullens James P · Rogers, ARS/N P21000113 N4802VWilcox Chad R · Muncy Valley, PAFirst renewal noticeBuilt 1967 · S/N 30082 N4803KBarker Shawn A · St Maries, IDBuilt 1979 · S/N P21000326 N4803PKcn Aero Club Inc · Overland Park, KSBuilt 1967 · S/N CE-111 N4803QBruntz Leslie H · Oxford, NEBuilt 1976 · S/N 18802541T N4804JPetges Nicholas A · Saint Louis, MOBuilt 1967 · S/N CE-122 N4805KH & M Aviation LLC · Hamilton, OHBuilt 1979 · S/N P21000327 N48061Olsen Mark G Trustee · Ketchikan, AKBuilt 1966 · S/N 185-1084 N4806JHall Thomas K DBA · Jupiter, FLBuilt 1966 · S/N D-8353 N4806YCondor Aviation LLC · Hanover, NHBuilt 1980 · S/N 21064012 N4807FWinkler Jeffery L · Brush, COFirst renewal noticeBuilt 1966 · S/N U206-0507 N4808JJm Beech V LLC · Winchester, TNBuilt 1966 · S/N D-8324 N4809JBenner David G · Prescott, AZBuilt 1966 · S/N D-8321 N480AGibbs Todd D · Walford, IABuilt 1969 · S/N E-181 N480HKorwel Tomasz W · Cedar Rapids, IABuilt 1967 · S/N D-8569 N480JKAugust-Marie Inc · Wilmington, DEBuilt 1997 · S/N E3103 N480S65 North Inc · Roswell, GABuilt 1967 · S/N 374 N4810Cox John C · Justiceburg, TXBuilt 1980 · S/N 18504111 N4810JMiller Wesley J · Silt, COS/N D-8331 N4810YInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 21064013 N4812FNorth American Aerial Surveys LLC · Tucson, AZBuilt 1966 · S/N U206-0512 N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265 N4813P4813p LLC · Newport, MEBuilt 1978 · S/N P21000115 N4815JRise Ronald B Jr · Purcellville, VABuilt 1966 · S/N CE-114 N4816JMorten Derek J · Northwood, NDBuilt 1981 · S/N T18803768T N4816RA&C Ag Aviation Inc · Unadilla, GABuilt 1975 · S/N 18802336T N4819QPuryear Rodney K · Pampa, TXBuilt 1976 · S/N 18802556T N481JCollins Jason · Mansfield, OHBuilt 1977 · S/N 21061580 N481PMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1977 · S/N U20603684 N481SAerogracia LLC · Heritage Ranch, CABuilt 1970 · S/N D-9094 N481TRBowen Tim S · Robstown, TXBuilt 1978 · S/N U20604383 N4820EHogan Mark C · Sisters, ORBuilt 1979 · S/N 18503880 N4822VCantrell David R · Albany, GABuilt 1968 · S/N 30092 N4823JHaunstein Manfred · Weirsdale, FLBuilt 1966 · S/N D-8337 N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524 N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883 N4825FLober Richard M · Bishop, CABuilt 1966 · S/N U206-0525 N4827PCarlson Chris · Redwood City, CABuilt 1978 · S/N P21000119 N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119 N4828KFlywerx LLC · Anchor Point, AKBuilt 1979 · S/N P21000336

Back to AD 86-13-04 R3