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.

N65407Clemson Flying Club Inc · Seneca, SCS/N 15281533 N65408Hendrix Aviation Inc · Plantation, FLBuilt 1978 · S/N 15281534 N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537 N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539 N6541URegistered aircraftBuilt 1962 · S/N 2324 N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913 N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482 N6542NHill Jonathan G · Dover, NHBuilt 1978 · S/N 21063098 N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765 N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550 N65439Pnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285287 N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855 N6543UGiesey William · Philadelphia, PABuilt 1962 · S/N 2326 N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766 N65440G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281554 N65449Hoeft Cliff A · Pilot Rock, ORBuilt 1978 · S/N 15281557 N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209 N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429 N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856 N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483 N65468Burger John J · Ocala, FLBuilt 1978 · S/N 15281569 N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102 N6546UBadlands Flyers Inc · Watford City, NDBuilt 1962 · S/N 2329 N65470Jt Aero LLC · Wilmington, DEBuilt 1978 · S/N 15281570 N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915 N6547NHart Anthony · Promise City, IABuilt 1978 · S/N 21063103 N65483American Aviation Inc · Brooksville, FLS/N 15281580 N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762 N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036 N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771 N65495Circle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 15281587 N65498Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281588 N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858 N654ACFlying Sparks LLC · Tomball, TXBuilt 1998 · S/N 1367-98 N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033 N654SMMcbride Stuart · Kingsland, TXBuilt 2012 · S/N 1467-2012 N65506Skelton James P Jr · Lithia Springs, GABuilt 1978 · S/N 15281593 N6550UGeorge Ladelle L · Ashley, NDBuilt 1963 · S/N 2333 N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769 N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771 N6551UAuker Donald · Lebanon, PABuilt 1962 · S/N 2334 N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774 N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775 N6552BHollenberg Randall W · Houston, TXBuilt 1979 · S/N 15283948 N6552FAir Planes LLC · Soddy Daisy, TNBuilt 1979 · S/N 17273239 N6552UGoldstein Meyer · Underwood, WABuilt 1962 · S/N 2335 N6553DLlv Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272861 N6553EZa Airport Rental LLC · Zanesville, OHBuilt 1978 · S/N 17272037 N6553KSchaffner Christopher · Dunmore, WVBuilt 1980 · S/N 17274211 N6553ULewis Orville W II · Memphis, TNBuilt 1962 · S/N 2336

Back to AD 80-25-07 R1