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.

N212TAJensen Paul · Exeter, NEBuilt 2005 · S/N 29-0392 N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214 N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950 N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851 N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372 N21314Merritt Robert · De Kalb, TXBuilt 1999 · S/N 30-0020 N2131FHerschberger Glen M · Willow, AKBuilt 1964 · S/N U206-0331 N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165 N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332 N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923 N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502 N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890 N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775 N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648 N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568 N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N2138ZPyle Richard B · El Paso, TXBuilt 1998 · S/N 29-0158 N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247 N213EOliver Craig J · Orion, MIBuilt 1965 · S/N TE-40 N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368 N213JDS&C Vending LLC · Scottsbluff, NES/N 310R0136 N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030 N213JWLipidex Corp · Marshfield, MABuilt 2004 · S/N 1089 N213LBPetro Larry D · Washington, DCBuilt 2004 · S/N 42051 N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335 N213QHardcopf Robert W · Apple Valley, MNBuilt 1965 · S/N D-7929 N213RJCrw Enterprise Holdings LLC · Newark, DEBuilt 2003 · S/N 0737 N213TBDonley John Roger · Eagle Lake, FLS/N 1056 N213WDHamill Enterprises LLC · Reinholds, PABuilt 2004 · S/N 1121 N2140DEaton Darryl S · Santa Barbara, CABuilt 2000 · S/N 30-0044 N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341 N2141LErwin James Erskine III · Newnan, GABuilt 1976 · S/N E-896 N21434Ad-A-Note LLC · Tarentum, PABuilt 1998 · S/N 29-0159 N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N2144LPrivate Paws LLC · Colorado Springs, COBuilt 1976 · S/N E-895 N2144PVanderhoof Brian L · Purcellville, VABuilt 1998 · S/N 29-0160 N2144ZBeerle Brion J · Anchorage, AKBuilt 1963 · S/N 18051244 N21452Moniri Robert · Cumming, GABuilt 1999 · S/N 30-0027 N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106 N2145XMitchell Derrick · Winter Park, FLBuilt 1998 · S/N 29-0138 N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778 N21479Focht Ronald D · Fort Myers, FLBuilt 1999 · S/N 30-0028 N2148LL&M Cleared2land LLC · Coral Gables, FLBuilt 1976 · S/N E-897 N2149LRocky Hill Airshows Inc · San Jose, CABuilt 1976 · S/N E-898 N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380 N214BBMessina Mark · Wallingford, CTBuilt 2001 · S/N 0085

Back to AD 86-13-04 R3