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.

N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572 N46090Sentinel Services Group LLC · Brooksville, FLBuilt 1981 · S/N 15285318 N46091Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17264176 N46092Breithaupt Tracy L · Alexandria, LAS/N 17257038 N4609LStork 1 LLC · Green Cove Springs, FLBuilt 1980 · S/N 15284197 N4609QN4609q LLC · Opa-Locka, FLBuilt 1973 · S/N 17261724 N4609SN4609s LLC · Verona, WIBuilt 1979 · S/N R18201355 N460ACArizona Skies Aviation LLC · Scottsdale, AZBuilt 2000 · S/N 440-2000 N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77 N460RWicklund Gerald G · Liberty, MOS/N 18267786 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042 N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046 N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047 N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235 N4610QBlaire William C · Rch Palos Vrd, CABuilt 1973 · S/N 17261725 N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049 N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051 N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052 N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054 N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056 N46126Knight Kenneth D · Stoneville, NCBuilt 1968 · S/N 17257057 N46128Meridian Aircraft Leasing LLC · Anniston, ALBuilt 1968 · S/N 17257059 N4612DPrecision Flight Training Inc · Newberg, ORBuilt 1979 · S/N 17272315 N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236 N46130Waltzer Eric · Riverside, CABuilt 1968 · S/N 17257061 N46132N46132 Leasing LLC · Kalispell, MTBuilt 1968 · S/N 17257063 N46133Baham Daniel R · Eunice, LAS/N 17257064 N46134Training Planes LLC · Tampa, FLBuilt 1978 · S/N 15283003 N46135Mc Masters James I · Springfield, VABuilt 1978 · S/N 15283004 N46138Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283005 N4613QSouth Seattle College · Seattle, WABuilt 1973 · S/N 17261727 N46143Stromme Shawn · Hazen, NDBuilt 1968 · S/N 17257070 N46144Bhm Corp · Claverack, NYBuilt 1968 · S/N 17257071 N46146Skylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15283007 N4614BUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1979 · S/N 15283552 N4614RAltair Aircraft LLC · Gainesville, FLBuilt 1979 · S/N 172RG0004 N46153Waldemar Mojica · Arecibo, PRBuilt 1968 · S/N 17257074 N46154Spann William J · Dothan, ALBuilt 1968 · S/N 17257075 N46157Gunderson Andrew C · Fond Du Lac, WIBuilt 1968 · S/N 17257077 N46158Cadillac Aircraft Services Inc · Cadillac, MIBuilt 1968 · S/N 17257078 N46161Robinson Russell W · Red Feather Lakes, COBuilt 1968 · S/N 17257080 N46163Bartel Christopher H · Williamsburg, PAS/N 17257082 N46166J Robert Finley & Associates Inc · Mountain Home, ARBuilt 1968 · S/N 17257084 N46167Towe Lannie · Madison, ALS/N 17257085 N46168Jack Brown Seaplane Base Inc · Winter Haven, FLBuilt 1968 · S/N 17257086 N4616CSan Angelo Aero L L C · San Angelo, TXS/N 21063576 N46177Busch Kacie · Mesa, AZBuilt 1968 · S/N 17257092 N4617CBrookhaven Corp · Buffalo, NYS/N 21063577 N4617SDelange Burke G · Scottsdale, AZBuilt 1979 · S/N R18201356

Back to AD 80-25-07 R1