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.

N751UGaines Charles C · Fernandina Beach, FLBuilt 2015 · S/N 1153-2014 N7521VLeslie Warren J · Sequim, WABuilt 1976 · S/N 177RG0818 N7523GTriple J Aviation LLC · Mcconnelsville, OHBuilt 1970 · S/N 17259223 N7523VTwc Aviation Services LLC · Merritt Island, FLBuilt 1975 · S/N 177RG0820 N7524FRobinson Robert L Jr · Homer, AKBuilt 1969 · S/N 207 N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224 N7526FMikulich Joseph · Bovey, MNBuilt 1969 · S/N 271 N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226 N7527FProtsman Bryan D · Anchorage, AKBuilt 1969 · S/N 208-70 N7528FRausch Bruce Thomas · Marysville, OHBuilt 1969 · S/N 212-70 N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228 N752DEEwers C Donald Trustee · Batavia, OHBuilt 1998 · S/N 1368-98 N7530VNicolaou John G · San Ramon, CABuilt 1976 · S/N 177RG0827 N7531FCanale Anthony · Friendswood, TXBuilt 1969 · S/N 286-70 N7532FPrather Carl L · Gilroy, CABuilt 1969 · S/N 272-70 N7533VWilliams Jeffrey D · Sparta, NJBuilt 1976 · S/N 177RG0830 N7534VCardinal Aero Group LLC · Marshall, ARBuilt 1976 · S/N 177RG0831 N7535VSchneider Martin G · Milford, NES/N 177RG0832 N7536VBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 177RG0833 N7537VHorizon Aeronautics Inc · Columbia, SCBuilt 1976 · S/N 177RG0834 N7538FSwensen Nathan E · Winnemucca, NVS/N 209-70 N7538VLee Walker S · Searcy, ARBuilt 1976 · S/N 177RG0835 N7539FHerkstroeter Caleb · Fairbanks, AKS/N 210-70 N753JBCraig Connor J · Mesa, AZBuilt 1966 · S/N 3377 N753RJMeyer Christopher R · Colchester, CTBuilt 1992 · S/N 693-92 N7540FMeierotto Noah J · Two Rivers, AKBuilt 1969 · S/N 211-70 N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240 N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242 N7542VCoastal Cosmetic And Implant Denistry LLC · Miramar Beach, FLBuilt 1976 · S/N 177RG0839 N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243 N7544FGrundy James W · West Greenwich, RIBuilt 1969 · S/N 284-70 N7544VGavazzo Victor Grille · Saint Peters, MOBuilt 1976 · S/N 177RG0841 N7546FPutman James G · Guntersville, ALBuilt 1969 · S/N 287-70 N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247 N7548GRetro Modern Aviation LLC · Manitou Springs, COBuilt 1970 · S/N 17259248 N754ACWillis Norman R · Wilsonville, ORBuilt 1998 · S/N 819-98 N7550G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259250 N7550VGamblin Elton Berry · Vienna, VAFirst renewal noticeBuilt 1976 · S/N 177RG0847 N75513Baird David J · Mount Shasta, CABuilt 1976 · S/N 17267773 N75515N75515 LLC · Palm City, FLBuilt 1976 · S/N 17267774 N75516Morristown Flying Service Inc · Talbott, TNBuilt 1976 · S/N 17267775 N75518Cloudhop LLC · Pinehurst, TXBuilt 1976 · S/N 17267776 N7551GNb Airdoc LLC · Aventura, FLBuilt 1970 · S/N 17259251 N75522Bradley Alexander L · Chesapeake, OHS/N 17267779 N75529Jmw Skyhawk LLC · Midland Park, NJBuilt 1976 · S/N 17267784 N75531Garner Michael A · Hernando, MSBuilt 1976 · S/N 17267786 N75532Darrow William A · Guthrie Center, IABuilt 1976 · S/N 17267787 N75535Skyhawk Cowboys LLC · Port Angeles, WABuilt 1976 · S/N 17267790 N75536N75536 LLC · Palm City, FLBuilt 1976 · S/N 17267791 N75537Jimenez Carlos · Davie, FLBuilt 1976 · S/N 17267792

Back to AD 80-25-07 R1