Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N6423USky West Aviation Inc Trustee · Albuquerque, NMBuilt 1962 · S/N 2170 N64240Lazy Eights Holdings LLC · Greenwood, INBuilt 1975 · S/N 17265114 N64241Monette Verne G · Anchorage, AKBuilt 1975 · S/N 17265115 N64242Goeke Randall D · Alexandria, MNBuilt 1975 · S/N 17265116 N64249N64249 LLC · Pottsboro, TXBuilt 1975 · S/N 17265123 N6424WCsapos Larry G · Ovid, MIBuilt 1964 · S/N 28-20494 N64250Ds Flight Services LLC · Battle Ground, WAS/N 17265124 N64254Terrasi John DBA · Pittsfield, PABuilt 1975 · S/N 17265127 N64255Gulf Coast Helicopters Inc · Pearland, TXS/N 17265128 N64256Dc Aero LLC · Ramona, CABuilt 1975 · S/N 17265129 N64258Desert Aircraft Rental LLC · El Centro, CABuilt 1975 · S/N 17265131 N64259Aerospatial LLC · Yakima, WABuilt 1975 · S/N 17265132 N6425JPetrich Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 28-4843 N6425ULaird Kevin E · San Diego, CABuilt 1962 · S/N 2172 N6425VRegistered aircraftBuilt 1980 · S/N 172RG0686 N64260Watts Reginald B · Parrottsville, TNBuilt 1975 · S/N 17265133 N64261Chickadee Aviation LLC · Auburn, MEBuilt 1975 · S/N 17265134 N64266Porter Vance T · Snohomish, WABuilt 1975 · S/N 17265138 N64267Hovnanyan Ari · Woodland Hills, CAFirst renewal noticeBuilt 1975 · S/N 17265139 N64268Boyadjian Khatchig Nareg · Pembroke Pines, FLS/N 17265140 N64269Flyit LLC · Camas, WABuilt 1975 · S/N 17265141 N6426FHigh Anxiety LLC · Kokomo, INBuilt 1979 · S/N 17273221 N6426JMunz Dennis F · Prairie Du Chien, WIBuilt 1968 · S/N 28-4844 N6426USmith Dustin J · Farwell, TXBuilt 1962 · S/N 2173 N6426VGlobal Aviators Academy Inc · Claremont, CAS/N 172RG0687 N6426YDoyle Thomas E · Hawley, MNBuilt 1973 · S/N 18-7309022 N64270Sundance Aviation Inc · Richland, WABuilt 1975 · S/N 17265142 N6427RNortheast Texas Aviation LLC · Chandler, TXBuilt 1966 · S/N 28-21607 N6427UPrecision Pilot LLC · Weston, FLS/N 2174 N64280Van Baren Brice P V · Silvana, WAFirst renewal noticeBuilt 1982 · S/N 17275540 N64281Richmor Aviation Inc · Scotia, NYBuilt 1982 · S/N 17275541 N64287Wetosha Flying Club Inc · Kenosha, WIBuilt 1982 · S/N 17275542 N6428JPhillips Roger Dale II · Westfield, NCBuilt 1968 · S/N 28-4846 N6428UGrossman James W · Eureka, SDBuilt 1962 · S/N 2175 N6428VDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 172RG0689 N6428WGeraghty John T · Long Beach, CABuilt 1964 · S/N 28-20498 N64291Price Kellous A · College Station, TXBuilt 1975 · S/N 17265144 N64294Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17265145 N64296Olmstead Clyde M · Fenton, MIBuilt 1975 · S/N 17265147 N64297Uptegraff Roy E III · Mc Kees Rocks, PABuilt 1975 · S/N 17265148 N64299Hawk Flying Club · Caledonia, MIBuilt 1975 · S/N 17265150 N6429VScott Dean A · Winchester, VABuilt 1980 · S/N 172RG0690 N6429WFarquharson Mark · Hampton, VABuilt 1964 · S/N 28-20499 N642AWHobart Aviation Inc · Akron, OHBuilt 1974 · S/N 17264124 N642AZHanson Jake Anthony · Loma Rica, CABuilt 1994 · S/N 20021C N642FWSharpe Thomas W · Asheboro, NCBuilt 2001 · S/N 81186 N642GDFitzpatrick Timothy Jr · Yerington, NVBuilt 1963 · S/N 2458 N642RKKellar Robert J Trustee · Woodbridge, CABuilt 2001 · S/N 20988 N642RSRomeo Sierra Aviation LLC · Sparks, NVBuilt 1980 · S/N 172RG0472 N642RVGitlin Joshua · Truckee, CABuilt 1992 · S/N 20804

Back to AD 79-10-03 R2