Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218 N173SKS Kamat Inc · Lexington, KYS/N 17272108 N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090 N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157 N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191 N17409Cirrus Aviation Inc · Sarasota, FLBuilt 2008 · S/N 172S10660 N1740CAmerican Aviation Inc · Brooksville, FLBuilt 2007 · S/N 172S10610 N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135 N1740TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12087 N1741SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12288 N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137 N1742SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12289 N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735 N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138 N1743LAir Inter LLC · Pittsburgh, PABuilt 2008 · S/N 172S10665 N1743SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12290 N1743VRegistered aircraftBuilt 1974 · S/N 17263736 N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140 N1745SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12291 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1749VVance Nicholas D · Bluffton, OHS/N 17263737 N174GFMarcus Air LLC · Plano, TXBuilt 1998 · S/N 17280532 N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235 N174HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8257 N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850 N174MEMaxxum Financial Group Inc · Destrehan, LABuilt 2000 · S/N 172S8452 N174THGh174th LLC · Jericho, NYBuilt 2020 · S/N 172S12442 N1750FLeggett Lee D · Murfreesboro, NCBuilt 1966 · S/N 17255145 N1752TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12097 N1754TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12099 N1754VAviation Specialist Inc · Apison, TNBuilt 1974 · S/N 17263739 N1755FSummit Aviation LLC · Belton, SCBuilt 1966 · S/N 17255150 N1756FHeistad Aviation Inc · Houston, TXBuilt 1966 · S/N 17255151 N1756TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12104 N1757FAcker David Lynn · Eugene, ORBuilt 1966 · S/N 17255152 N1758VKrickhahn Kermit O · Marion, TXBuilt 1974 · S/N 17263740 N1759FOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 17255154 N1759VFelbaum Jill E · Tecumseh, MIS/N 17263741 N175EJudy Richard L · Beverly, WVBuilt 1964 · S/N 17251210 N175KAAir Cruiser LLC · New York, NYBuilt 1973 · S/N 17262117 N175MENorth Perry Flight Center Inc · Fort Lauderdale, FLBuilt 2000 · S/N 172S8437 N1760FPark Rapids Avionics Inc · Park Rapids, MNBuilt 1966 · S/N 17255155 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1761FTuttle Trent · Deforest, WIS/N 17255156 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109 N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743 N1765FKohler Daniel J · Mapleton, ORS/N 17255160 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110

Back to AD 90-06-03 R1