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.

N625TRVictor Pathways Management LLC · Newport Beach, CABuilt 2005 · S/N 1730 N625VSHeritage Airplane One LLC · Tullahoma, TNBuilt 2005 · S/N 1517 N6260VPcb Aircraft · Johnstown, OHBuilt 1967 · S/N D-8591 N6261KGlasmon Inc · Nacogdoches, TXBuilt 1981 · S/N E-1993 N6261VSundance Air Service Inc · Alameda, CAS/N D-8593 N6262KBrz Air LLC · Beaumont, TXBuilt 1979 · S/N P21000395 N6262VGk Ag LLC · Broxton, GAS/N D-8592 N6263VJansen Aviation Services And Sales LLC · Monticello, IABuilt 1967 · S/N D-8594 N6264VHagstrom Christopher · Sauk Centre, MNBuilt 1967 · S/N D-8596 N6265VFankhauser Thomas D · Montgomery, TXBuilt 1967 · S/N D-8595 N6266HNovi Inc · Ruby, AKBuilt 1978 · S/N 20700457 N6266NSai Flight Services Inc · Greer, SCBuilt 1982 · S/N E-2001 N6267XWahlen Per · Newtown Square, PABuilt 1982 · S/N D-10391 N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313 N6269NJuliet Tango Capital LLC · Saginaw, MIBuilt 1978 · S/N 340A0454 N6269VGopher One LLC · Willernie, MNBuilt 1967 · S/N D-8598 N626CRSmiles Aviation LLC · Kerrville, TXBuilt 1978 · S/N E-1367 N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280 N626SKelly Kendall J · Mckinney, TXBuilt 1966 · S/N D-8052 N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851 N6271RAir Jag LLC · Garden City, KSBuilt 1982 · S/N TH-1331 N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141 N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517 N6275EValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 18504017 N6276VHilsenroth Robert · Fernandina Beach, FLBuilt 1967 · S/N D-8603 N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460 N6277VBlue Jay Aviation · Lake Placid, FLS/N D-8601 N6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N U20606211 N6278VMontana Excursions LLC · Modesto, CABuilt 1968 · S/N D-8602 N6278YTown & Country Aviation LLC · Sunnyvale, CABuilt 1981 · S/N 21064318 N627AJJorfam Properties LLC · Dripping Springs, TXBuilt 1974 · S/N D-9583 N627BTAviation Global Inc · Saint Augustine, FLBuilt 1981 · S/N P21000768 N627DJLarocque Daniel · Anchorage, AKBuilt 1975 · S/N 18502634 N627KCHorsehead LLC · Ada, MIBuilt 1990 · S/N CE-1480 N627PMRichardson David J Trustee · West Memphis, ARS/N 29-0332 N627RGSummer Flight LLC · Selbyville, DEBuilt 2004 · S/N 1243 N6280PAirborne Equipment Inc · Hendrum, MNBuilt 1979 · S/N P21000159 N6282BBig G Air LLC · Durango, COBuilt 1978 · S/N 21062735 N6282VBautista Lance C · Modesto, CABuilt 1967 · S/N TE-463 N6283NValiair Lc Trustee · Casper, WYBuilt 1982 · S/N E-2002 N6284UBonanza Group LLC · Phoenix, AZBuilt 1982 · S/N E-2003 N6284VBradsher Harold Michael · Troy, MOBuilt 1967 · S/N D-8605 N62854High Flight Connections LLC · Roanoke, INBuilt 1982 · S/N E-2008 N6285HWhitetail LLC · Anchorage, AKBuilt 1978 · S/N 20700466 N6285NMoon Dipper Aviation LLC · Deerfield Beach, FLBuilt 1982 · S/N E-2005 N6285XSpires William A · Columbus, GABuilt 1982 · S/N E-2006 N6287VGilbert Gavin J · Granbury, TXBuilt 1967 · S/N D-8607 N6287XWallen Joe · Knoxville, TNS/N 500A-1250-75 N6288VJaysix LLC · Greeley, COBuilt 1967 · S/N TE-459 N628AKBaron Partners LLC · Bessemer, ALS/N TH-1614

Back to AD 86-13-04 R3