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.

N69PTAerofix Structural Service LLC · Horn Lake, MSS/N 1397-143 N69WPHutcheson Jon · Greencastle, INBuilt 1973 · S/N 32-7440015 N6ARBluewater Airmotive Corporation · Wilmington, DEBuilt 1973 · S/N 31-7300914 N6HTColorado By Air LLC · Salida, COBuilt 2003 · S/N T20608387 N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079 N7008FSouthbound Aviation LLC · Jackson, TNBuilt 1976 · S/N 32-7740012 N700ABSale Reported · Lewes, DESale reported, pending cancellationBuilt 1977 · S/N 61P-0401-139 N700AKCampbell Mark D · Ashford, ALBuilt 1979 · S/N 70017 N700CMoss Donald · Pinecrest, FLBuilt 1974 · S/N 31-7405497 N700GCRicks Auto Clinic Inc · Raytown, MOBuilt 1977 · S/N 32-7740054 N700GLPitcock Aviation LLC · Tompkinsville, KYBuilt 1967 · S/N 31-83 N700HWHotel Whiskey LLC · Sylvania, OHBuilt 1999 · S/N T20608034 N700KFTurbine Motor Conversions LLC · Orange, CABuilt 1984 · S/N H-10 N700LDNorthridge Consulting Enterprises LLC · Santa Clarita, CABuilt 1981 · S/N 62P-928-8165051 N700MFEtavan LLC · Satellite Beach, FLBuilt 1976 · S/N 61P-0282-064 N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012 N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007 N700YWHorwath Ricky N · Saint James City, FLBuilt 1979 · S/N 70029 N7010FEconomou Michael · Falls Church, VAS/N 32R-7780051 N7016FNations One For Christ · Duluth, MNS/N 32R-7780052 N701DMPacific Fleet Aviation LLC · Rochester, NYBuilt 1966 · S/N 27-3131 N701JGAerostar LLC · Newport Beach, CABuilt 1969 · S/N 61-0034 N701YWHorwath Ricky N · St James City, FLBuilt 1979 · S/N 70031 N702PGOn Three Angels Wings LLC · Melbourne, FLBuilt 1984 · S/N 60-8423009 N70394Halford Richard W · Eagle River, AKS/N 18502147 N7039CJdk Aviation LLC · Kalispell, MTBuilt 1975 · S/N 32-7640041 N703CWWasem Investments LLC · Salem, ORBuilt 2005 · S/N T18208464 N703DPProfessional Aviation Group LLC · Wilmington, DES/N 27-3861 N703TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 2035 N703WMMoore Tom · Basalt, COBuilt 2005 · S/N T18208461 N7045GBig Rock Aviation LLC · Big Rock, ILBuilt 1976 · S/N 32R-7680272 N704MCCrowther Construction Inc · Pleasant View, UTBuilt 2004 · S/N T18208251 N7052HScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554130 N70543Tk Group Holdings LLC · Wilmington, DEBuilt 1976 · S/N 31-7612029 N705JWTulare County Sheriff · Visalia, CABuilt 2004 · S/N T20608490 N705SFLet Industries LLC · Lewes, DEBuilt 1974 · S/N 27-7405311 N705TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 2215 N7069DSo Many Trees LLC · Hanover, NHBuilt 1978 · S/N 31-7812081 N706SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 27-7405394 N707JPSierra Hotel Inc · Van Buren, ARS/N 60-8423018 N707VTPrecision Air Vt LLC · Las Vegas, NVBuilt 2004 · S/N T20608470 N70846Dc Aero LLC · Ramona, CABuilt 1971 · S/N 274593 N708THH & H Contractors · Leesburg, TXFirst renewal noticeBuilt 2005 · S/N T20608578 N709AMAirtrust LLC - 13 - Series 13 Trustee · Sheridan, WYBuilt 2001 · S/N 2101 N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027 N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030 N70GGAnderson Gary · Port Orange, FLBuilt 2018 · S/N L2K-141 N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208 N70JMTriple M Investments LLC · Whitehall, PABuilt 1976 · S/N 32R-7680259 N70KCLa Chabola Aviation LLC · Plano, TXBuilt 1976 · S/N 61P-0291-070

Back to AD 81-12-06 R1