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.

N80376Aerial Specialties Inc · Decatur, TXS/N 17266558 N80377Seagull Flying Club Inc · San Jose, CABuilt 1976 · S/N 17266559 N80379Early Kevin S · Oregonia, OHBuilt 1976 · S/N 17266560 N8037GGuidry John M · Pensacola, FLBuilt 1970 · S/N 177RG0037 N80380Skywarrior Flight Training Inc · Pensacola, FLBuilt 1976 · S/N 17266561 N80382Sorce Sal · Clark, NJBuilt 1976 · S/N 17266563 N80389J F Aviation Inc · Joliet, ILBuilt 1976 · S/N 17266565 N8038WMctaggart Briar C · Adelanto, CAS/N 179 N80396Osprey Holding Company LLC · Foley, ALBuilt 1976 · S/N 17266569 N8039GGreen Mortgage Corp · Walworth, WIBuilt 1970 · S/N 177RG0039 N803ABAlo Aviation LLC · Titusville, FLBuilt 1978 · S/N 15282246 N803BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1979 · S/N 17272258 N803DWRamirez Denise K · Corona, CAS/N 24-1701-14 N803HPP & W Investments Inc · Wilmington, DEBuilt 1982 · S/N 17275609 N803RMAs Filed LLC · Culver City, CABuilt 1969 · S/N 690039 N8040EHolt Todd E · Delta, UTBuilt 1968 · S/N 680015 N80414Garn Darrell L · Palmetto, GABuilt 1976 · S/N 17266576 N80419Korona Lawrence K · West Paterson, NJBuilt 1976 · S/N 17266578 N80421Kuder Kyp E · Rogers, NDBuilt 1976 · S/N 17266580 N80425Fellows Roy H · Augusta, KSBuilt 1976 · S/N 17266582 N8042FFlying Hawks Inc · Palmyra, WIBuilt 1975 · S/N 17264378 N80436N80436 LLC · Columbia, MSBuilt 1976 · S/N 17266585 N80439Oklahoma State University · Stillwater, OKBuilt 1976 · S/N 17266586 N8043GConnor Robert L · North Little Rock, ARBuilt 1971 · S/N 177RG0043 N80440Rockey John · Jupiter, FLBuilt 1976 · S/N 17266587 N80442Washburne Seth P · Dallas, TXBuilt 1976 · S/N 17266588 N8044GTml Services LLC · The Villages, FLS/N 177RG0044 N80454Tadao LLC · Tucson, AZBuilt 1976 · S/N 17266593 N80456Barash Geva S · Ashland, MABuilt 1976 · S/N 17266595 N80458Kolpack Glenn H · Sonora, CABuilt 1976 · S/N 17266597 N80469Hetherly Bryce D · Clintondale, NYS/N 17266603 N80470Coddiwomple LLC · Newberg, ORBuilt 1976 · S/N 17266604 N80471Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 17266605 N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606 N80475Texas Southern University · Houston, TXS/N 17266608 N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609 N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611 N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612 N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613 N80487Williams Fredrick Glen · Auburn, ALS/N 17266614 N80489P & K Aviation LLC · Neshkoro, WIBuilt 1976 · S/N 17266615 N80490American Patrols Inc · Midland, TXS/N 17266616 N80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1976 · S/N 17266617 N80495Space Coast Aero LLC · Melbourne, FLBuilt 1976 · S/N 17266619 N80496Bickel Gregory A · Mckinleyville, CABuilt 1976 · S/N 17266620 N80497Ducksrus LLC · Indianapolis, INBuilt 1976 · S/N 17266621 N8049GStone & Phillips Aviation LLC · Youngstown, FLBuilt 1971 · S/N 177RG0049 N804BD G Leasing LLC · Houston, TXBuilt 1976 · S/N 17266584 N804BLFlores Omar Javier · New Braunfels, TXBuilt 1979 · S/N 17273041 N804JSButler Jack L · Bennington, OKBuilt 2004 · S/N 491-2004

Back to AD 80-25-07 R1