Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958 N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003 N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103 N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164 N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050 N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082 N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011 N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013 N811CBRfw Construction Group LLC · Dyersburg, TNBuilt 1974 · S/N 31-7512001 N811PJObrien Neal J · Milton, GABuilt 1969 · S/N 3051 N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237 N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8126PCsm Holding LLC · Boscobel, WIBuilt 1963 · S/N 24-3379 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113 N8137VAeolus Aviation LLC · River Hills, WIBuilt 1980 · S/N 32R-8029003 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N81436P&C Construction Inc · Chattanooga, TNBuilt 1979 · S/N 32R-8029045 N8144GDistant Horizons LLC · Park City, UTBuilt 1979 · S/N 32R-8029047 N8148YJustison David L · Hillsboro, ILBuilt 1982 · S/N 32R-8329005 N814CVJam Zoom Yayos LLC · Manheim, PABuilt 2002 · S/N 2137 N814FARivinius Sam · Danville, CABuilt 2003 · S/N T18208214 N81573Jsham LLC · Sheridan, WYS/N 32-8024004 N8158BRegistration Pending · Springfield, MORegistration pendingS/N 32R-8229038 N8158YRobert Lea Investments LLC · Molalla, ORBuilt 1980 · S/N 32-8024006 N8159SGaither David G Executor · Houston, TXS/N 32R-8029059 N8159YRaven Aviation LLC · Murrayville, GABuilt 1980 · S/N 32R-8029060 N815TAS3 Air Aviation LLC · Henderson, NVBuilt 1976 · S/N 32R-7680356 N8165JLloyd J Cleaver D O LLC · Kirksville, MOBuilt 1980 · S/N 32-8024010 N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063 N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049 N8169ZHarper Hugh Holdings LLC · Alvarado, TXBuilt 1980 · S/N 32-8024012 N816ARCustom Curb Inc · Ventura, CABuilt 2005 · S/N T18208451 N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562 N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267 N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067 N8170YRaven Aeronautics Ltd · Monument, COBuilt 1980 · S/N 32R-8029069 N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291 N8172PWison Keene · Abbeville, GABuilt 1981 · S/N 32R-8129028 N8173PLao Investments LLC · Meeker, COBuilt 1980 · S/N 32-8024015 N8177YElite Approach LLC · Chesterfield, MOBuilt 1982 · S/N 32R-8229042 N817TRRobinson Trent · Havana, FLBuilt 2000 · S/N 3257132 N8180DBobert Bunny LLC · Wilmington, DEBuilt 1980 · S/N 32R-8029075 N8180FTag International Corporation Inc · Sheridan, WYBuilt 1980 · S/N 32R-8029076 N8185CKirkland Kerry G · Spring, TXBuilt 1975 · S/N 32-7640053 N8185WAlaska Media LLC · Anchorage, AKBuilt 1980 · S/N 328024017

Back to AD 91-21-01 R1