Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N19194Smokey Bear Air LLC · Cascade Locks, ORBuilt 2005 · S/N T18208428 N191FAHarvey Taz E · Danville, CABuilt 2003 · S/N T18208191 N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229 N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051 N191TASanborn Map Company Inc · Colorado Springs, COBuilt 1974 · S/N 31-7401230 N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020 N19277Roundtree Sod Service Inc · Jacksonville, FLBuilt 2005 · S/N T18208437 N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037 N1938JCsi Asset Management Inc · Naples, FLBuilt 1976 · S/N 14036 N1938SCavu Aviation LLC · North Yarmouth, MEBuilt 1973 · S/N 3167 N193TM193 Tango Mike LLC · Winter Haven, FLS/N 84 N194PMDye David A · Point Clear, ALBuilt 1993 · S/N 4622146 N194ZUsda Forest Service Fepp · Malvern, ARBuilt 1965 · S/N 1510-182 N19500Wright Bros Flying Club LLC · Lewes, DEBuilt 1994 · S/N 4622163 N1953HBritton Scott M · Fairview, TXBuilt 1977 · S/N 32-7740044 N195JGN195jg Aviation LLC · Port Republic, NJBuilt 1994 · S/N 4622173 N1963JTeam Robinson Holdings LLC · Denver, NCS/N 328024038 N1968TGilbert Zachary A · Jekyll Island, GABuilt 1968 · S/N 32-40376 N1969HTrn Aviation LLC · Mcallen, TXS/N 3257066 N196DBBe Right Back Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 27-7405273 N1970PWootton Donald W · Houston, TXBuilt 1981 · S/N 32R-8129044 N1977JPicornell Francisco J · Malabar, FLBuilt 1976 · S/N 14080 N197LABg Family Limited Partnership · Edinburg, TXBuilt 1997 · S/N 4636098 N197MAShore Air LLC · Trappe, MDBuilt 1997 · S/N 4636079 N197PMRegistered aircraftBuilt 1997 · S/N 4636086 N1982HWasley David L · Harwinton, CTBuilt 1977 · S/N 32R-7780212 N1982KN1982k LLC · Wilmington, DEBuilt 2005 · S/N T18208442 N1983HGroeteke Robert W · Ravenna, NEBuilt 1977 · S/N 32R-7780213 N1986VSpeer 182 LLC · Kalispell, MTBuilt 2005 · S/N T18208443 N198GME B Marine LLC · Lantana, FLBuilt 1974 · S/N 32-7440126 N198JCLong Bayou LLC · Vero Beach, FLBuilt 1998 · S/N 3257028 N198TCSky Ryder Aviation LLC · Lewisville, TXBuilt 1998 · S/N 3257047 N198WCy Properties Inc · Durango, COBuilt 1997 · S/N 3257012 N1994BGxi Holdings LLC · Fort Worth, TXBuilt 1994 · S/N 27-0186 N199DSIsland Wings Inc · Fort Lauderdale, FLBuilt 1973 · S/N 31-7400980 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374 N19JPSheldon Law Pllc · Scottsdale, AZBuilt 1997 · S/N 4636119 N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516 N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597 N19SCSacred Heart Medical Group Inc · Riverside, CABuilt 2001 · S/N T18208101 N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478 N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826 N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327 N1NXBirchwood Farms Inc · Hope Mills, NCBuilt 1962 · S/N TD-536 N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186 N1THall George E Jr · Hillsborough, NCBuilt 1969 · S/N 60-0014 N1UGRegistered aircraftS/N 32R-7780308 N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018 N200CEBrewer Erich J · Thompson, MOBuilt 1977 · S/N 14257

Back to AD 81-12-06 R1