Registered aircraft · 18,495

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.

N8134RFolsom Airplane Co LLC · Longwood, FLBuilt 1974 · S/N CE-524 N8135AB And S Aviation LLC · Hamilton, ILBuilt 2003 · S/N 0674 N8135RKeyt Richard C · Granbury, TXBuilt 1974 · S/N D-9696 N8135VMcminn Aviation LLC · Ackerman, MSBuilt 2003 · S/N 0658 N8136ERunyon Rodney D · Portland, TNBuilt 1991 · S/N E-2614 N8136RDreamstead Recreational Vehicles LLC · Kalispell, MTBuilt 1974 · S/N E-612 N8137GTwo Ten K LLC · Upper Sandusky, OHBuilt 1971 · S/N 21059437 N8137LShreve Jerry · Warrensburg, MOBuilt 1974 · S/N 21060624 N8137PFlying Daze · Batavia, OHBuilt 1991 · S/N E-2653 N8137RWestdale Aviation LLC · Shreveport, LABuilt 1974 · S/N D-9660 N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438 N8138JOil Tech Air LLC · Golden Valley, MNBuilt 2003 · S/N 0663 N8138QAnderson Marshall H · Anchorage, AKBuilt 1978 · S/N 18503633 N8138RDavenport Clifford M · Bonita, CABuilt 1974 · S/N E-587 N8138SLavalley Asset Management Inc · Potsdam, NYBuilt 2003 · S/N 0681 N8139CEnhanced Aviation LLC · Wilmington, DEBuilt 2003 · S/N 0661 N8139KN8139k LLC · Bethalto, ILBuilt 2003 · S/N 0662 N8139LWashburn Kyle A · Yukon, OKBuilt 1974 · S/N 21060626 N8139RStiller David L · Sedona, AZBuilt 1974 · S/N CE-522 N8139VAyers Samuel · Canandaigua, NYBuilt 2003 · S/N 0685 N813CDDirt Cheap Aviation LLC · Greencastle, INBuilt 2002 · S/N 0141 N813CHBlech Andreas J · Grants Pass, ORBuilt 1973 · S/N D-9536 N813DMAp-1 LLC · Newman Lake, WABuilt 1975 · S/N 21060946 N813JSDiamondhead Aviation LLC · Omaha, NES/N 32R-8229034 N813MMRc Air Ventures LLC · New York, NYBuilt 2000 · S/N E-3342 N813MRRxcare Healthcare LLC · Jacksonville, FLS/N 1010 N813SWWolff Scott · Missoula, MTBuilt 1979 · S/N U20605296 N8140NViolette James · Glendale, AZBuilt 1992 · S/N CE-1713 N8140SDc Air LLC · Nampa, IDBuilt 2003 · S/N 0684 N8141FSpecial Flying Group LLC · Greensboro, NCBuilt 2003 · S/N 0699 N8141GBitter Creek Investments LLC · Cascade, IDS/N 21059441 N8141LLand Aerial Services LLC · Conway, ARBuilt 2003 · S/N 0665 N8141QMike Taus & Associates LLC · Sandusky, OHBuilt 2003 · S/N 0676 N8141YTrifunac Alexander D Trustee · Boulder, COBuilt 1991 · S/N CE-1592 N8142WByrne Real Estate Group LLC · Charlotte, NCBuilt 1993 · S/N CE-1729 N8143DOught9 LLC · East Helena, MTBuilt 2003 · S/N 0678 N8143GRegistration Pending · Sparks, NVRegistration pendingBuilt 1971 · S/N 21059443 N8143JFly Girl Aviation LLC · Little Rock, ARBuilt 1991 · S/N CE-1595 N8144QOcf Air LLC · Phoenix, AZBuilt 1970 · S/N 414-0044 N8144ZBuckeye Aircraft Holdings LLC · Dayton, OHBuilt 2003 · S/N 0700 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N8145USrsly Aviation LLC · Wilmington, DEBuilt 2003 · S/N 0683 N8146JFabios Construction Inc · Concord, MABuilt 2003 · S/N 0675 N8146LFranzeskos LLC · Helena, MTBuilt 2003 · S/N 0680 N8146QOak Gulch LLC · Killdeer, NDBuilt 1975 · S/N U20603097 N8147VSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 188-0397 N8148FReid-Sanderman LLC · San Diego, CABuilt 2003 · S/N 0769 N8148MDmac Aircraft LLC · Savannah, GABuilt 2003 · S/N 1357 N8149WRcc Air LLC · Dallas, TXBuilt 2003 · S/N 0695 N814CDD&J Construction & Real Estate LLC · Jupiter, FLBuilt 2002 · S/N 0143

Back to AD 86-13-04 R3