Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333 N469EHClaybrook Douglas E · Little Rock, ARBuilt 1978 · S/N R18200335 N469JAmerican Champion Aircraft Corp · Rochester, WIBuilt 2013 · S/N 1122-2012 N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61 N469RAChorice Kenneth · Bartlett, TNBuilt 1978 · S/N 38-78A0531 N46CSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N P21000413 N46ECHermans Greg · Virginia Beach, VABuilt 1975 · S/N 22-1218 N46HSBlackburn Aviation Air LLC · Mesa, AZS/N 3430 N46JLWeaver Aviation LLC · Yucaipa, CABuilt 1975 · S/N 20-1169 N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942 N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144 N4700HRegistered aircraftBuilt 1979 · S/N 24-0825 N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388 N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389 N47028My Way Aviation LLC · Weston, FLS/N 15283159 N47029Geronimo Aviation LLC · Scottsdale, AZBuilt 1979 · S/N 15283160 N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074 N4702HAbove All Others Consulting Inc · West Palm Beach, FLBuilt 1979 · S/N 24-0812 N4702PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284801 N4704GRegistration Pending · Spencerville, OHRegistration pendingS/N 17273326 N4704HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283966 N47053Semagin Arkadi · Burlingame, CABuilt 1979 · S/N 15283163 N4705DN4705d LLC · Oklahoma City, OKS/N 17272335 N4705HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283967 N4705QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 152-85053 N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336 N4706SGreat Lakes Aviation LLC · Burtchville, MIBuilt 1979 · S/N R18201392 N4707LJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284222 N4707SBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201393 N4707TVan Ausdall John C · Spring Branch, TXBuilt 1981 · S/N R18201739 N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013 N4709SMolinar Antonio L · El Paso, TXBuilt 1979 · S/N R18201395 N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011 N47108Ace Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N 15283170 N4711BPinnacle Aviation Services Inc · Encinitas, CABuilt 1979 · S/N 15283591 N4711LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284223 N4711VLiddy Alan A · Seabrook Island, SCS/N 172RG0368 N47120Shipe Jacqueline M · Louisville, TNBuilt 1979 · S/N 15283174 N4712KMclellan Bruce A Trustee · Bend, ORBuilt 1979 · S/N P21000262 N4712NTimberline Helicopters Inc · Sandpoint, IDBuilt 1979 · S/N 18267302 N47133Sunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283178 N4713BSmith Peter J · Excelsior, MNBuilt 1979 · S/N 15283593 N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596 N4714FHastings Stephen J · Palmer, AKS/N 17273075 N4714RAlford William J · Erie, MIBuilt 1979 · S/N 172RG0014 N4715JClarke Brent H · Neversink, NYS/N 17273666 N4715WKelley Christopher L · La Quinta, CABuilt 1980 · S/N P21000624 N4717BCoastal Flight Inc · Tierra Verde, FLBuilt 1979 · S/N 15283595 N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598 N4717HLinder Marlin D · Morrison, COBuilt 1979 · S/N 24-0819

Back to AD 80-25-07 R1