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.

N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N7742VNorbury Ross · Boonville, MOBuilt 1969 · S/N 1495 N774FSHilty Kenneth C · Greensboro, NCBuilt 2000 · S/N 3257192 N775DSFlight Ventures LLC · Charlotte, NCS/N T18208498 N775RAMojave 775ra LLC · Roseburg, ORBuilt 1982 · S/N 31P8414038 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N7761VLangley Richard A · Sheyenne, NDBuilt 1969 · S/N 1518 N7772HGws Contractors Inc · Bonne Terre, MOBuilt 2004 · S/N T18208257 N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515 N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336 N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528 N7775BCessna 206 LLC · Sun Valley, IDBuilt 2000 · S/N T20608197 N7777FPlastech Corporation · Atlanta, GABuilt 1989 · S/N 4622016 N7777GNittany Flyin LLC · Amarillo, TXBuilt 1991 · S/N 4622118 N7779TDavidson Thad · Whitehouse, TXBuilt 1978 · S/N 32R-7887196 N777BSMathison John M · Del Norte, COBuilt 1969 · S/N 61-0043-84 N777CMCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1412-147 N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019 N777HZCb Auto Inc · Columbia, MDS/N 31-7405177 N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777RZRapid 6 Flyers LLC · Rapid City, SDBuilt 1970 · S/N 32-40907 N777SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 31-596 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777WLucky Shot LLC · Dayton, OHBuilt 1977 · S/N 32R-7780297 N777XTBeach Travis W · Bishop, CABuilt 2005 · S/N 1-B N777YUEvenhaim Ronen · Canoga Park, CABuilt 1980 · S/N 32R-8029065 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N7783VWarhol Peter J · Peever, SDBuilt 1970 · S/N 1536 N778EJobin Lyle · Saint Augustine, FLS/N 61P-0434-161 N7799VCb Aerial Application LLC · Kirksville, MOBuilt 1970 · S/N 1552 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77AJGreen Nicholas S · Lakeland, TNBuilt 1976 · S/N 32R-7680371 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N77DUChaffee Merilyn D · Angwin, CABuilt 1999 · S/N 3257101 N77DXWolfert Jonathan M · Dallas, TXBuilt 1998 · S/N 27-0253 N77EWBellanca Aviation Of Blairstown LLC · Andover, NJBuilt 1974 · S/N 74-32-137 N77RHFelty Johnathon T Sr · Auburn, PABuilt 1974 · S/N 32-7440103 N77SBYanta Chris J · Rockport, TXBuilt 1977 · S/N 32-7740086 N77TTTurley James H · Plainwell, MIBuilt 1976 · S/N 32R-7680244 N77YYN77yy Corp Trustee · Wilmington, DEBuilt 1999 · S/N 32-57120 N780GCAir Eye Md LLC · Carolina, PRBuilt 1978 · S/N 317812069 N781DKSpruce Ave Air LLC · Phoenix, AZBuilt 2006 · S/N T18208597 N7824TRoss Charles · Midlothian, TXBuilt 1978 · S/N 32R-7887032 N7827SStar Aviation Inc · Melville, NYBuilt 1982 · S/N 31-8252035 N782DEBoard Susan W · Moundsville, WVBuilt 1968 · S/N 31-224 N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88 N7857FGeorge William Jesse · Alamogordo, NMBuilt 1976 · S/N 32R-7780084 N785HCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636206 N785SASpringate Scott T · Chelan, WABuilt 2001 · S/N T18208035

Back to AD 81-12-06 R1