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.

N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909 N3251WCorporate Flight Mangement LLC · Dallas, TXBuilt 1995 · S/N EA-576 N3252JBas Part Sales LLC · Greeley, COS/N E-3252 N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952 N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954 N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215 N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292 N325DDQuick Michael D · Middletown, CAS/N 21062748 N325JWKlug Transport Inc · Farmington, MOBuilt 2012 · S/N TH-2340 N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825 N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990 N325RPN325rp Corp · Willow Spring, NCBuilt 1985 · S/N P21000848 N325SRFingerhut Steven · Cross Plains, TXBuilt 1966 · S/N TE-65 N3260FGilbert Aviation Inc · Wilmington, DEBuilt 1995 · S/N TH-1760 N3261CHeyman Steven · San Mateo, CABuilt 1996 · S/N TH1785 N3262XDns Aviation LLC · Fulton, CABuilt 1995 · S/N E-2962 N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301 N3264QWilton William H · Kailua Kona, HIBuilt 1967 · S/N 401-0064 N3268QSuperior Food Distributors LLC · Naples, FLBuilt 1967 · S/N 401-0068 N3269HEom LLC · Little Rock, ARBuilt 1996 · S/N E-2999 N326KB4 Wingmen LLC · Sandy, UTBuilt 1973 · S/N CE-422 N326SCuruchet Shay · Kaycee, WYBuilt 1969 · S/N D-9067 N326TJBarnett John M · Fredericksburg, TXS/N 29-0043 N326TKClark Shawn B · Fairhope, ALBuilt 2003 · S/N 0716 N326WRRoquemore William A Jr · Lakeland, GABuilt 1966 · S/N 308 N3270JBerry Matthew G · Creedmoor, NCBuilt 1996 · S/N TH-1770 N3270RMotorman Of America Corp · Wilmington, DEBuilt 1995 · S/N E-2970 N3271GPettit James P · Newport, VABuilt 1995 · S/N E-2971 N3272VWooldridge Homes LLC · New Haven, KYBuilt 1995 · S/N E-2972 N3273MLindeen Michael · Anchorage, AKBuilt 1967 · S/N 185-1210 N3279MValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 310R1891 N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452 N327AMSchmidt Steven P · West Springfield, VABuilt 2003 · S/N 0691 N327BLCinotto Robert L · Rhome, TXS/N TE-1043 N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166 N327CPSu Farms Transportation LLC · Hale Center, TXBuilt 1973 · S/N 73-30559 N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535 N327DBonanza Flyers LLC · Aurora, COBuilt 1965 · S/N D-7801 N327DTLafferty Jason · Marana, AZBuilt 2004 · S/N 0972 N327GSkysix Aircraft Management LLC · Saginaw, MIBuilt 1994 · S/N E-2910 N327MWW. Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1980 · S/N 414A0531 N327RHInfineon Properties Of Montana LLC · Helena, MTS/N 0958 N327TALeblanc Joseph E Jr · Houston, TXBuilt 1984 · S/N 340A1809 N3281KWallace Architects LLC · Columbia, MOBuilt 1979 · S/N TH-1006 N3288MClute Kenneth N · Las Vegas, NVBuilt 1980 · S/N 310R1895 N328BNothing Wasted LLC · Bunker Hill, INBuilt 1966 · S/N D-8307 N328EMConcierge Diamonds Inc · Los Angeles, CABuilt 1985 · S/N 46-8508087 N328HRShuster David · Fredericksburg, VABuilt 1979 · S/N D-10269 N328JWL & R Cirrus Inc · Portage, PABuilt 2002 · S/N 0225 N328MN328m LLC · Marion, INBuilt 2001 · S/N TH-1992

Back to AD 86-13-04 R3