Skip to content

Registered aircraft · 54,015

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

N7166ESutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 52166 N7166FRegistration Pending · Kenly, NCRegistration pendingS/N 15063766 N7166TCentral Aviation LLC · White City, ORBuilt 1959 · S/N 46766 N71670Wreyford James S · Marble Falls, TXBuilt 1969 · S/N 18259711 N71675Sea To Summit Aero LLC · Mertzon, TXBuilt 1969 · S/N 18259713 N71678Mitchell Flying Service LLC · Cushing, OKBuilt 1969 · S/N 18259714 N7167ATucker Tim · Hopkinsville, KYBuilt 1956 · S/N 29267 N7167FSteinhoff Daniel P · Santa Rosa, CABuilt 1966 · S/N 15063767 N7167XMckissack Douglas R · Pooler, GABuilt 1961 · S/N 15059267 N71685Hamilton Thomas S DBA · Priest River, IDBuilt 1969 · S/N 18259718 N7168ERampton Curtis D · Reno, NVBuilt 1959 · S/N 52168 N7168GDurbin John W · Lovington, ILBuilt 1969 · S/N 17258868 N7168MWindh Steven R · Reedley, CABuilt 1958 · S/N 55468 N7168SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15067868 N71699Grit Ventures LLC · Throckmorton, TXBuilt 1969 · S/N 18259722 N7169TBrent Ephron D · Arriba, COBuilt 1959 · S/N 46769 N71705Wilson Alfred C · Salisbury, NCBuilt 1969 · S/N 18259724 N7170EMcknight Thomas N · Fredericksburg, TXBuilt 1959 · S/N 52170 N7170GSs Skyways LLC · Becker, MNBuilt 1969 · S/N 17258870 N7170XMccardle Guy D · Burnham, PABuilt 1961 · S/N 15059270 N71710Warp Six Aviation LLC · Manitowoc, WIBuilt 1969 · S/N 18259725 N7171EPhillips John · Vernal, UTBuilt 1959 · S/N 52171 N7171QMcnamara Bradley W · Seattle, WABuilt 1972 · S/N 17260471 N7171SGuerra Carrie E · Lompoc, CABuilt 1976 · S/N 18265077 N71726Mayes John · Carson City, NVBuilt 1969 · S/N 18259730 N7172EGibson James T · Brookhaven, MSBuilt 1959 · S/N 52172 N7172QRounds Agronomy LLC · Pierre, SDS/N 17260472 N7172SLovaas Darryl G Trustee · Crescent City, CABuilt 1967 · S/N 15067872 N71731Brisson Michael Paul · Enterprise, ALBuilt 1969 · S/N 18259733 N71735Dinota Dominick · Wallkill, NYBuilt 1969 · S/N 18259735 N71736Nixon Leland Bryan · Stapleton, ALBuilt 1969 · S/N 18259736 N7173ADuke Billy L · Ormond Beach, FLBuilt 1956 · S/N 29273 N7173EMcpherson David R · Sturgis, SDBuilt 1959 · S/N 52173 N7173GSale Reported · Haiku, HISale reportedBuilt 1969 · S/N 17258873 N7173MCronin Larry D · Mountain Home, IDBuilt 1958 · S/N 55473 N7173QWesterly Av Group LLC · Westerly, RIS/N 17260473 N7173TDidier Thomas · Port Washington, WIS/N 46773 N71748Altom Marvin L · Reno, NVS/N 18259737 N7174ESuazo Tito L · Glendale, AZBuilt 1959 · S/N 52174 N7174GMaloney John T · Deer Park, NYBuilt 1969 · S/N 17258874 N7174SBelasco Thomas D II · Bridgeport, WVBuilt 1967 · S/N 15067874 N7174TPaddock Spencer · Palmer, AKBuilt 1960 · S/N 46774 N7174XMcdaniel John P III · Marianna, FLS/N 15059274 N71752Wings Over Ouray LLC · Ouray, COBuilt 1969 · S/N 18259738 N71753Gibbs Aubrey Damon · Cumming, GABuilt 1969 · S/N 18259739 N7175FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063775 N7175GMontgomery Monty · Cave Spring, GABuilt 1969 · S/N 17258875 N7175QTcb Solutions LLC · Milledgeville, GABuilt 1973 · S/N 18262042 N7175TTischer William D · Shoreview, MNBuilt 1959 · S/N 46775 N71766Habermann William J · Hardwick, NJBuilt 1969 · S/N 18259746

Back to AD 87-20-03 R2