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.

N19762Boyertown Flying Club Inc · Devon, PABuilt 1976 · S/N 17702590 N19763N19762 LLC · Tigard, ORBuilt 1976 · S/N 17702591 N19766Owens Wilbur · Rch Palos Vrd, CAS/N 17260734 N19768Glacier Flight Training LLC · Whitefish, MTS/N 17260736 N1976FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273064 N19771Tetoff Logan P · Bethel, AKBuilt 1972 · S/N 17260739 N19773Burtch Timothy J · Washington, DCBuilt 1972 · S/N 17260740 N19775Skyhawk Leasing LLC · Odenville, ALBuilt 1972 · S/N 17260742 N19777Rtd Aviation LLC · Hillsborough, NJBuilt 1972 · S/N 17260744 N19778Marx John C · Edgewood, WABuilt 1972 · S/N 17260745 N1977FJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17273065 N1977QPeabody Jeffery L · Vinemont, ALBuilt 1973 · S/N 177RG0377 N1977SRiley James E · Sparks, NVBuilt 1976 · S/N 172-67687 N1977YTrychon Stephen A · Sterling, MABuilt 1964 · S/N 264 N19781Carbono Alvaro J · Valdez, AKBuilt 1972 · S/N 17260746 N19782Herber David · Stanwood, WABuilt 1976 · S/N 17702594 N19783Sky Hi Inc · Frederick, MDBuilt 1976 · S/N 17702595 N19787Reinhardt Ryan S · Russell, KSBuilt 1976 · S/N 17702596 N19789Remhof Marc · Inver Grove, MNBuilt 1972 · S/N 17260753 N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711 N1978JJasinski David W Trustee · Petaluma, CABuilt 1978 · S/N 24-0563 N1978NStansfield Jacob M · Kalispell, MTBuilt 1977 · S/N 17268953 N1978YMeinert Matthew A · Columbia, MOFirst renewal noticeBuilt 1964 · S/N 265 N19791Smithburg Richard · Lockridge, IABuilt 1972 · S/N 17260755 N19792Dunfee Dalton M Trustee · Corinth, MEBuilt 1972 · S/N 17260756 N19793Lopez Vicente · San Juan, PRBuilt 1976 · S/N 17702598 N19794Lasater John M G · Grants Pass, ORBuilt 1972 · S/N 17260758 N19795Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1972 · S/N 17260759 N19797Marple Jon · Mesa, AZBuilt 1972 · S/N 17260760 N197AWO'Steen James D Jr · Laurel, FLS/N 670295 N197BCSeruset Jeffrey G · Butler, PABuilt 2004 · S/N 461-2004 N197NDKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1998 · S/N 409-98 N197THN197th LLC · Sammamish, WABuilt 1977 · S/N 15280093 N19800Cardinal LLC · South Easton, MABuilt 1976 · S/N 17702599 N19801Salas Elizabeth Robles · Miami Beach, FLBuilt 1972 · S/N 17260764 N19802Westdahl Merrill W · Chugiak, AKBuilt 1972 · S/N 17260765 N19803American Patrols Inc · Midland, TXBuilt 1972 · S/N 17260766 N19804Cm3 LLC · North Las Vegas, NVBuilt 1972 · S/N 17260767 N19805C & R Leasing LLC · Fairbanks, AKS/N 17260768 N19806Overseas Aviation Inc · Wilmington, DEBuilt 1976 · S/N 17702600 N19807Lightbourn Ryan R · Lake Mary, FLS/N 17260770 N1980YJorgensen Sarah B · Anchorage, AKS/N 267 N19811Dow Benjamin L · Fairfax, VTBuilt 1972 · S/N 17260774 N19813Davol Christine · New Hampton, NHS/N 17260776 N19814Dix Aviation LLC · Indianapolis, INBuilt 1976 · S/N 17702601 N19817Maxey John D · Hillsboro, KYBuilt 1972 · S/N 17260780 N19819Northwoods Air LLC · Orono, MEBuilt 1972 · S/N 17260782 N19820Su Zaihao · Auburn, WABuilt 1972 · S/N 17260783 N19824Gadola Alan J · Maple Grove, MNBuilt 1976 · S/N 17702605 N19828Walker Clint · Indianapolis, INBuilt 1976 · S/N 17702606

Back to AD 80-25-07 R1