Skip to content

Registered aircraft · 40,472

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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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.

N1472FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273007 N1472UEbben Robert A · New London, WIS/N 17267139 N1474ESuffolk County Police Pilots Assoc · Bayport, NYBuilt 1978 · S/N 17271015 N1474FJlb Aviation Services LLC · Woodbine, NJBuilt 1979 · S/N 17273008 N1474PMccormick Robert E · Selah, WAS/N 23-541 N1474UHentges Jerry J · Morris, MNBuilt 1976 · S/N 17267141 N1474XKjeldsen Frederik C M · Poughkeepsie, NYBuilt 1975 · S/N 28-7515407 N1475VGlobal Flight Training Solutions Inc · Immokalee, FLS/N 17263610 N1476TBough Jayce K · El Dorado Hills, CAS/N 28-7225530 N1476UTampa Bay Aviation Inc · Clearwater, FLBuilt 1976 · S/N 17267143 N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309 N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306 N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612 N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313 N1478XMello Edward R Jr · Land O Lakes, FLBuilt 1975 · S/N 28-7525292 N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735 N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016 N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146 N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411 N147AVRegistered aircraftN-number assigned, not yet registeredS/N 1262 N147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeBuilt 2003 · S/N 447-2003 N147DSDavis Brady · Acampo, CABuilt 1973 · S/N 439 N147EBMalott David · Glade Park, COBuilt 1975 · S/N 20-1165 N147FWParr William R Jr · Mason, TXS/N 80771 N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545 N147JKKuehn John · Sammamish, WABuilt 1999 · S/N 2257 N147JSScrobola James M · Wyoming, PABuilt 2019 · S/N SCROBOLA 0001 N147LFRed Baron LLC · Middletown, DES/N 161 N147MAReaddick Rocy W · Kingsland, GABuilt 2005 · S/N 501-2005 N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000 N147MTMiddle Tennessee State University · Murfreesboro, TNBuilt 1974 · S/N 18-7409136 N147PCAlexander John S · Warrensburg, NYBuilt 2004 · S/N 1366-2004 N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019

Back to AD 80-04-03 R2