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.

N186GMGorosave John Michael · Midland, TXBuilt 1990 · S/N 24-3148 N186RABig T Aviation LLC · Wilmington, DEBuilt 2003 · S/N 1338-2002 N1870QTrebilco David R · Cedar Park, TXBuilt 1972 · S/N 177RG0270 N1870VSanders-Smith Kimberly K · Napa, CABuilt 1974 · S/N 17263776 N1871GGrizzle Jason · Roscoe, TXBuilt 1968 · S/N 107 N1871QHemstad Christopher L · Portland, ORBuilt 1972 · S/N 177RG0271 N1871VMcpherson Philip D · Battle Creek, MIBuilt 1974 · S/N 17263777 N18720Bailey Bryan M · New Waverly, TXBuilt 1976 · S/N 17702548 N18725Ayers Francis H Jr · Palm Coast, FLBuilt 1976 · S/N 17702549 N1872GMcninch Floyd S · Greenville, MES/N 614 N1872QQualitair LLC Trustee · MichelstadtBuilt 1972 · S/N 177RG0272 N18738Cardinal Flyers Inc · Northborough, MABuilt 1976 · S/N 17702552 N18739Monaco Michael · New Windsor, NYFirst renewal noticeBuilt 1976 · S/N 17702553 N1876QShuford Lon R · Cumming, GABuilt 1972 · S/N 177RG0276 N1878QKachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 177RG0278 N187CTKoukol Dan F · Roseville, CABuilt 1979 · S/N 24-0776 N187HAA&J Air Sales Inc · San Antonio, TXBuilt 1971 · S/N 17259696 N187JWBriley Christopher P · Lynchburg, VABuilt 1970 · S/N 700056 N187LCArd Sammy · Pamplico, SCBuilt 1999 · S/N 1272-99 N187RAWarden Stephen M · Sugar Land, TXBuilt 2005 · S/N 499-2005 N187TATech Air LLC · Lexington Park, MDBuilt 1964 · S/N 2688 N187TYAutry Brenden · Guyton, GABuilt 1978 · S/N 240652 N1880GSchool Of Missionary Aviation Technology · Ionia, MIBuilt 1968 · S/N 50 N1880QNewby Patrick · Mentor, OHBuilt 1972 · S/N 177RG0280 N1883QMitchell Philip J · Arlington, TXS/N 177RG0283 N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781 N1885GGoodfriend Neal · Sanger, TXS/N 144 N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285 N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782 N1887GJewett Cody C · Isabel, SDBuilt 1968 · S/N 117 N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287 N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288 N1889GRainbow Flying Service LLC · Moses Lake, WABuilt 1968 · S/N 93 N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289 N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783 N188BCWaldron Elijah L · Murfreesboro, TNBuilt 2019 · S/N 598-2019 N188DHDunworth Jack R · Rutledge, GABuilt 1968 · S/N 680119 N188GHAer Lightfoot LLC · Alpena, MIBuilt 1964 · S/N 525 N188HTReady Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N T18803430T N188RACook Gary Lee · Ontario, CABuilt 2005 · S/N 976-2005 N188RSVardaman Charles · Little Rock, ARBuilt 1979 · S/N 341-80 N1892GSveen Jeffrey S · Edinburg, NDS/N 612 N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784 N1893GDuston James D · Columbus, MSBuilt 1968 · S/N 619 N1893QSauk Prairie Aviators LLC · Merrimac, WIBuilt 1972 · S/N 177RG0293 N1894GWeyhe Joel J · Medford, ORBuilt 1968 · S/N 610 N1895GPost Morgan C · Council Bluffs, IABuilt 1968 · S/N 617 N1897QGuadarrama Joe R · Vacaville, CABuilt 1972 · S/N 177RG0297 N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785 N1898XScott Ayer Interests LLC · Phoenix, AZBuilt 1982 · S/N R18201898

Back to AD 80-25-07 R1