Skip to content

Registered aircraft · 2,861

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:97-05-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1') 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:97-05-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1')
  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:97-05-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1')
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.

N318JHAir Hoffmann LLC · Saint Louis, MOBuilt 2014 · S/N 525-0817 N318JPSurric LLC · Shreveport, LABuilt 2024 · S/N 525-1174 N318NWMed Jets USA Inc · Boca Raton, FLBuilt 1980 · S/N 318 N318RWMueller Aero Inc · Prairie Du Sac, WIBuilt 1990 · S/N 560-0051 N3190VTop Flight LLC · Wilmington, DEBuilt 1947 · S/N D-626 N3196VOpenshaw Charles M · Huggins, MOBuilt 1947 · S/N D-632 N319CFOcean Drive Bulgaria Corp · Wilmington, DEBuilt 2001 · S/N 319 N319JDHollingsworth Intergalactic LLC · Clinton, TNBuilt 1997 · S/N 5250216 N31CJ212 Investments Of Montana LLC · Collinsville, OKBuilt 2001 · S/N 525-0474 N31CVN31cv LLC · Thompsons, TXBuilt 1996 · S/N 560-0351 N31HAHampden Aviation Services Inc · Florence, MABuilt 2014 · S/N 525-0829 N31HDHotel Delta LLC · Sacramento, CABuilt 1998 · S/N 525-0261 N31HKN31hk Inc · Miami, FLBuilt 1975 · S/N 016 N31RARoyal Air Freight Inc · Waterford, MIBuilt 1979 · S/N 288 N31SPBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 525-0874 N31WEWorldwide Equipment Of Tn Inc · Knoxville, TNBuilt 2000 · S/N 5250362 N3203VGumar Sherko · Scottsdale, AZS/N D-640 N3208VIrby Darrell L · Keller, TXS/N D-646 N320CBHoneymoon Properties IV LLC · Winfield, ALBuilt 1993 · S/N 560-0207 N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523 N320GWSky Wheeels LLC · Prince Frederick, MDBuilt 1981 · S/N 180 N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366 N320MKAdaka-Sb LLC · Orlando, FLBuilt 1982 · S/N 370 N3212VIvy James III · Seligman, AZBuilt 1947 · S/N D-650 N321EMRiomar Sky LLC · Warrington, PABuilt 2023 · S/N 525-1152 N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515 N321RRambarran Brian D · Clarence Center, NYBuilt 1994 · S/N 525-0049 N3222VRohsner Thomas A · Nacogdoches, TXBuilt 1947 · S/N D-800 N3224VHerman Ira · Albuquerque, NMBuilt 1947 · S/N D-667 N322GTInde Aero LLC · Chandler, AZS/N 550-1030 N322VAEagle Cap Leasing Inc · Enterprise, ORBuilt 1996 · S/N 560-0399 N3233VSanchez Alfonso H · Albuquerque, NMBuilt 1947 · S/N D-676 N3238VAltman Michael A · Austin, TXS/N D-682 N323EBOzark Air LLC · Prairie Grove, ARBuilt 1999 · S/N 550-0893 N323EZN323ez LLC · Amarillo, TXBuilt 1996 · S/N 525-0128 N323NENcw Aircraft LLC · Wenatchee, WABuilt 1997 · S/N 560-0442 N3244VMalouf Jeannette D H · Palm Harbor, FLBuilt 1947 · S/N D-689 N324BDGodwin Aviation LLC · Dunn, NCBuilt 2008 · S/N 525-0674 N324JWVip Jet Transportation Inc · Bishop, CABuilt 1981 · S/N 324 N324LMCirrus Wings LLC · Jefferson City, MOBuilt 1996 · S/N 560-0395 N3255VAcker Timothy G · Gig Harbor, WABuilt 1947 · S/N D-702 N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325 N325NWKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 325 N325PKBlackdog Jet LLC · North Las Vegas, NVBuilt 1998 · S/N 550-0850 N325SJMamia Motorsport · Katy, TXBuilt 1979 · S/N 550-0097 N325WPBlue Ridge King Inc · Martinsville, VABuilt 2000 · S/N 550-0933 N3261VBaldwin Larry Lee · Clarinda, IABuilt 1947 · S/N D-708 N3262MU S Department Of Homeland Security · Washington, DCBuilt 1991 · S/N 550-0652 N3262VAbernathy Richard M · Overland Park, KSBuilt 1947 · S/N D-709 N3268VObrien Joseph F IV · Pierson, FLBuilt 1947 · S/N D-716

Back to AD 97-05-03 R1