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.

N628BBAmerican Lumber And Plywood Inc · Guntersville, ALBuilt 2005 · S/N 42073 N628BWWings Like Eagles LLC · Wilmington, DES/N 310R0682 N628CDCtd Aviation LLC · Greensboro, NCBuilt 2019 · S/N TH-2515 N628DKEastgate Investments LLC · Henderson, NVBuilt 1965 · S/N 18255786 N628JWJuliet Whiskey LLC · Roanoke, VABuilt 1979 · S/N 414A0241 N628MDClarkton Aviation III LLC · Clarkton, MOBuilt 1992 · S/N TH-1662 N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503 N628SECane John Paul · San Jose, CABuilt 2000 · S/N EA-655 N628TTTollen Troy J · Austin, TXBuilt 1978 · S/N 21063058 N628YTAdventist World Aviation · Wilson, NCBuilt 1977 · S/N U20603816 N6290NShrauner Reid · Elkhart, KSBuilt 1978 · S/N 340A0464 N6290WLord Of The Wings LLC · Syracuse, NYBuilt 1981 · S/N P21000742 N6291CSatl Ranch Aviation LLC · Midland, TXBuilt 1980 · S/N 21063857 N6292GHutchison Glen A · Traphill, NCFirst renewal noticeS/N 055 N6292NAvjets LLC · Miami, FLFirst renewal noticeBuilt 1978 · S/N 340A0465 N6292ZBlv Aviation LLC · Columbus, INBuilt 1982 · S/N E-2010 N6294PMarkowich Darren K · Gilbert, AZBuilt 1978 · S/N P21000163 N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322 N6296VFollis Chad · Hartford, IABuilt 1967 · S/N D-8621 N6297HHackbart Gary H · Las Vegas, NVBuilt 1978 · S/N 20700472 N6297LMccaskill Justin E · Montgomery, TXBuilt 1982 · S/N E-2012 N6297XMike Sierra LLC · Brookings, SDS/N 340A0468 N6297YL&L Aviation LLC · Baden, PAS/N 21064323 N6298URed Roadrunner LLC · Richmond, KYBuilt 1982 · S/N CE-995 N6298VRegistered aircraftBuilt 1967 · S/N D-8611 N6298XN111es Inc · Monticello, INS/N E-2013 N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858 N6299PDanlars Aircraft Sales · Mccall, IDBuilt 1978 · S/N P21000165 N6299XSouth Florida Exotics LLC · Missoula, MTBuilt 1982 · S/N E-2016 N629BEWbme LLC · Warrenville, SCBuilt 1999 · S/N E-3287 N629EBRuff Cattle Co · Hanston, KSBuilt 1997 · S/N E-3085 N629WSPrecision Avionics Specialists · Griffin, GABuilt 1970 · S/N 21059363 N62AUFaust Richard J · Richmond, TXBuilt 1981 · S/N EA-247 N62BBUp And Down Aviation LLC · Perry, GABuilt 1973 · S/N TH-328 N62BJCapital Dental Management Inc · Dover, DEBuilt 1973 · S/N D-9414 N62CVTessos Air Service Inc · Wilmington, DEBuilt 1987 · S/N TH-1523 N62DWSagamore Sky LLC · Jericho, NYS/N 4210188 N62ECSharp Aviation LLC · Pauls Valley, OKBuilt 1985 · S/N 18504428 N62EMHarris Jesse C IV · Laurel Park, NCBuilt 1966 · S/N D-8081 N62ESBeushausen Mark O · Woodland Hills, CABuilt 1997 · S/N 010 N62GBBeavers Glenn A · Wichita Falls, TXBuilt 1967 · S/N D-8566 N62GGReduction Drive Motors LLC · Redmond, ORBuilt 2015 · S/N ESDD-199 N62GHBas Part Sales LLC · Greeley, COBuilt 1999 · S/N 29-0190 N62GMRankin Ty · Amarillo, TXBuilt 1980 · S/N E-1713 N62HWWestwind Holdings LLC · Wilmington, NCBuilt 2000 · S/N 29-0239 N62JBHcb Media LLC · Los Angeles, CAS/N E-1160 N62JRN62jr LLC · Lakeside, MTBuilt 1988 · S/N CE-1298 N62KHMullen Robert W Jr · Healdsburg, CABuilt 2010 · S/N E-3923 N62LEMayfield Aviation LLC · Salem, UTBuilt 1977 · S/N E-1171 N62PKRegistration Pending · Lillington, NCRegistration pending, canceledBuilt 1995 · S/N TH-1751

Back to AD 86-13-04 R3