Skip to content

Registered aircraft · 6,349

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-02-R2') 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-02-R2') 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-02-R2')
    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-02-R2')
  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-02-R2')
  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-02-R2')
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.

N3796VMace Wade L · Ottawa, KSBuilt 1949 · S/N 15217 N3797MNorlin William E · Greencastle, INBuilt 1947 · S/N 12-2721 N37983Spani Wayne W · Corona, CAS/N 809 N3798MGrow David A · Gloucester Point, VABuilt 1947 · S/N 12-2724 N37997Flying Brick LLC · Monroe, NCBuilt 1980 · S/N WA-190 N379LDObryan Joel M · Brownwood, TXBuilt 1989 · S/N 1379 N37KTJr Ace LLC · Indianapolis, INBuilt 2001 · S/N 1 N37PHHoye Michael B · Heath, TXBuilt 2000 · S/N 001 N37RGMindspring LLC · New Orleans, LAFirst renewal noticeBuilt 1991 · S/N 2099 N37RMMiller Richard N · Oxford, IABuilt 1978 · S/N 157 N37ZQMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 15282684 N3801RFial Ronald A · Milwaukie, ORBuilt 1980 · S/N WA-191 N38024Hancock Aviation LLC · Baton Rouge, LABuilt 1980 · S/N WA-197 N38025Missaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1980 · S/N WA-198 N38026Terra Scott M · Vacaville, CABuilt 1980 · S/N WA-202 N3804EGregory Michael P · Clayton, DEBuilt 2020 · S/N 5426 N38054Burr William L Jr · Johns Creek, GAFirst renewal noticeBuilt 1980 · S/N WA-201 N38062Marquez Naoko Quena · Henderson, NVBuilt 1980 · S/N WA-204 N3807KFaucette Micro Systems Inc · Fallon, NVS/N WA-200 N3807MRenner Robert C · Erie, PABuilt 1947 · S/N 12-2729 N38086Autumn Crocus LLC · Cincinnati, OHS/N WA-210 N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211 N3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeBuilt 1980 · S/N WA-212 N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213 N380KPPeterson Timothy J · Watertown, SDBuilt 1947 · S/N 11-1586 N3812QN3812q LLC · San Diego, CABuilt 1981 · S/N WA-214 N3812UBasquit Kenneth H · Pittsburgh, PABuilt 1980 · S/N WA-215 N38131Rivera Ar · Nevada City, CABuilt 1941 · S/N 5874 N3816MAnderson Jeremy J · Ankeny, IABuilt 1947 · S/N 12-2737 N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225 N381AVNelson Allen R · Oakdale, MNS/N 38-78A0638 N38245Foster Gifford L · Torrington, WYBuilt 1941 · S/N 5916 N38251Bazil Nick G · Lehighton, PAS/N 5-923 N3826MBaugh Caleb · Carthage, MOBuilt 1947 · S/N 12-2568 N382CFTurner Noah S · Gilbert, AZBuilt 1979 · S/N 38-79A1043 N382DPBurns Craft LLC · Wilmington, DEBuilt 1971 · S/N MSA115001 N382PTTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 38-78A0003 N3833MMiranda Michael R · Enterprise, ALBuilt 1947 · S/N 12-2750 N3834MChristoph Mark H · Omak, WABuilt 1947 · S/N 12-2751 N3835MLentfer Sheryl A · Anchorage, AKBuilt 1947 · S/N 12-2752 N38384Baisden James Brett · Manassas, VABuilt 1981 · S/N WA-231 N3838MAhumada George Ramon · Palmer, AKS/N 12-2759 N38397Registered aircraftS/N WA-232 N383ACWest Valley Flying Club · Palo Alto, CABuilt 2001 · S/N 1383-2001 N3840MMillman Troy J · Oshkosh, WIBuilt 1947 · S/N 12-2761 N38422Cline David R · Maryville, TNBuilt 1941 · S/N 5-972 N3843MMcdermott Michael · Ballston Spa, NYBuilt 1947 · S/N 12-2754 N38462Krystofiak Steven · Scottsdale, AZBuilt 1981 · S/N WA-244 N3846UKrystofiak Steven · Scottsdale, AZS/N WA-242 N3847MCrosswinds Stol Inc · Wasilla, AKBuilt 1947 · S/N 12-2758

Back to AD 80-25-02 R2