Skip to content

Registered aircraft · 25,369

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.

N63BSPfinx LLC · Chapel Hill, NCBuilt 1992 · S/N 24-3286 N63CVClark Terry L · Bartlesville, OKBuilt 1979 · S/N 386-79 N63DABass Lake Aviation LLC · Webster, WIBuilt 1998 · S/N 1238-98 N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616 N63GMBmi Aviation LLC · Hallandale Beach, FLBuilt 1990 · S/N 24-3182 N63HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 2021 · S/N 1198-2022 N63HESkoog Rodney D · White Bear Lake, MNBuilt 2004 · S/N 452-2004 N63JDD'Angelo Joseph P · Callicoon Center, NYBuilt 1979 · S/N 17272940 N63MMNzere Michael · Crowley, TXBuilt 1963 · S/N 2569 N63MYRegistered aircraftBuilt 2008 · S/N 10692008 N63PKRegistered aircraftBuilt 1965 · S/N 734 N63RMclenaghan Alvin N · Phoenix, AZBuilt 1965 · S/N 858 N63RWSmith Jacques F · Anchorage, AKBuilt 1978 · S/N 15280763 N63SASky View Aviation LLC · Lenoir, NCBuilt 1973 · S/N 17261610 N63WTRodencal Richard · Wisconsin Rapids, WIBuilt 1998 · S/N 404-98 N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949 N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955 N6400QHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285244 N6400UAudetat Thomas Jr · Marana, AZBuilt 1962 · S/N 2147 N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662 N64012Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275505 N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961 N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963 N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964 N6401ALynch Rick W · Lewisburg, TNS/N 38-78A0416 N6401QHunter Donald J · Scottsdale, AZBuilt 1967 · S/N 670141 N6401UBlue Sky Aviation Adventures LLC · St George, UTS/N 2148 N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663 N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966 N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969 N64027Snyder Brent R · Dallas, TXBuilt 1985 · S/N R18202021 N6402NManos Con Alas Aviation · Stateline, NVBuilt 1978 · S/N 21062978 N6402QMooney Mooney Mooney LLC · Gig Harbor, WABuilt 1967 · S/N 670142 N6402UMccleave Thomas · Everett, WABuilt 1962 · S/N 2149 N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664 N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507 N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980 N6403MPlane N Simple Aviation LLC · Los Angeles, CABuilt 1980 · S/N 15284711 N6403QMiller Fred J · Sahuarita, AZBuilt 1967 · S/N 670143 N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665 N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509 N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981 N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983 N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984 N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986 N6404UPhiyawa Airplane Holding Inc · Argyle, TXBuilt 1962 · S/N 2151 N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990 N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512 N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994 N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995

Back to AD 80-25-07 R1