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.

N6351QRegistered aircraftBuilt 1967 · S/N 670434 N6352NGilbreath Tony C DBA · Olustee, OKBuilt 1967 · S/N 306 N6352VMiles Richard A · Macon, NCBuilt 1980 · S/N 172RG0640 N6353DDeland Aviation LLC · Deland, FLBuilt 1979 · S/N 17272739 N6354QSibley Kevin W · Porter, TXBuilt 1967 · S/N 670437 N6355CDutch Air LLC · Kalispell, MTBuilt 1980 · S/N 21063874 N6355QEinck John J · Stockton, ILBuilt 1967 · S/N 670438 N6355TBrazos Valley Flight Services LLC · College Station, TXBuilt 1984 · S/N R18201994 N63569Eastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17275452 N6356QKline Larry C · Fountain Hills, AZBuilt 1967 · S/N 670439 N6357DRice John Jr · Maddock, NDBuilt 1979 · S/N 17272743 N6357NHamlin Andrew James · Fairbanks, AKBuilt 1967 · S/N 95 N6357QCable Air Inc · Upland, CABuilt 1981 · S/N 15285235 N6358NLarson Lynn R · Fargo, NDBuilt 1967 · S/N 6 N6358QBibb Kenneth · Sayre, OKBuilt 1967 · S/N 670443 N6359DFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17272745 N6359QMccurry Mack P · Weatherford, TXBuilt 1967 · S/N 670442 N6359WScarlett Cameron O · Madison, WIBuilt 1981 · S/N P21000757 N635MMHsp Holdings LLC · Farmington, NMBuilt 1978 · S/N R18200700 N63609Filtenborg Daniel · Shelbyville, MIBuilt 1981 · S/N 17275455 N6360NEdwards Construction Group LLC · Washington, MOS/N 18267830 N63612St Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1981 · S/N 17275456 N63628Black Hills Airplanes LLC · Rapid City, SDBuilt 1981 · S/N 17275458 N6362AMillican Clifford A · Burleson, TXBuilt 1979 · S/N 21063523 N6362NGoodwin David C · Boulder, WYBuilt 1967 · S/N 54 N6362QHanley Clint · Edgewood, NMBuilt 1967 · S/N 670445 N6363QLawrence John C · Belle Chasse, LABuilt 1967 · S/N 670446 N6364CSukhakarta Rentals LLC · Cedar Park, TXBuilt 1980 · S/N 21063875 N6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1979 · S/N 17272750 N63659Droege Robert Michael · Saratoga Springs, NYBuilt 1981 · S/N 17275463 N6365FRindo David J · Lowell, MABuilt 1979 · S/N 17273203 N6365NSouth Dakota State University · Brookings, SDBuilt 1967 · S/N 41 N63663Lake Aviation LLC · Murfreesboro, TNBuilt 1981 · S/N 17275465 N6366FDerose Joseph F · Salt Springs, FLBuilt 1979 · S/N 17273204 N6366NCarlson Eric S · Kodiak, AKBuilt 1967 · S/N 15 N6366QLibre Air LLC · Norfolk, VABuilt 1967 · S/N 670449 N6367QCc Aviation Inc · Tracy, CABuilt 1981 · S/N 15285236 N63681American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275467 N6368NS&S Aviation LLC · Morse, LABuilt 1969 · S/N 161 N6368QRegistration Pending · Kalispell, MTRegistration pendingS/N 15285237 N63694Upper Valley Aero LLC · Hanover, NHBuilt 1981 · S/N 17275470 N6369NEberhart Royce R · Covington, GABuilt 1967 · S/N 44 N6369TRegistered aircraftBuilt 1984 · S/N R18201998 N636CXNewton Property Leasing LLC · Greene, IABuilt 1978 · S/N 17271789 N636DBVectored Solutions Inc · Everett, WABuilt 2023 · S/N 636-2023 N63702Smith Brian E Trustee · Richland, WABuilt 1981 · S/N 17275471 N6370DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272756 N6370QDesert Breeze Aviation LLC · Phoenix, AZBuilt 1967 · S/N 670453 N63715Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275473 N63716Michael Thomas O Trustee · Oldsmar, FLBuilt 1981 · S/N 17275474

Back to AD 80-25-07 R1