Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N321RMBigler & Associates Aviation Inc · Cameron Park, CABuilt 1979 · S/N 25-0230 N3229QHansen Ralph H Jr Trustee · Encinitas, CABuilt 1977 · S/N 34-7770222 N322DBPoint To Point LLC · Wadsworth, OHS/N 25-0446 N322DDPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 25-0414 N322FCFuego Enterprises Inc · Atlanta, GABuilt 2003 · S/N 3449275 N322SSJohnson Robert Wayne · Lebanon, TNBuilt 1978 · S/N 28R-7803353 N3239VMccue Michael R · Missoula, MTBuilt 1977 · S/N R1722243 N323CCBarrett James P · North Little Rock, ARBuilt 1978 · S/N 28R-7803206 N323FTPudil Zachary Thomas · West St Paul, MNBuilt 2004 · S/N 1432 N323XLedgerwood Chris · Anchorage, AKBuilt 1975 · S/N 6131C N32456Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 34-7570023 N3253KWarbird Adventures Inc · Ocoee, FLS/N 1246 N32555Harvest Aviation · Wauchula, FLBuilt 1974 · S/N 34-7570032 N3256QManzella Aviation LLC · Brandon, FLBuilt 1977 · S/N 28R-7703098 N325TTSuperior Flying Service LLC · Superior, WIBuilt 1983 · S/N 348333006 N325ZLipovsky Kevin C · Commerce Township, MIBuilt 2004 · S/N 1407 N32624Rio Aviation LLC · Wilmington, DES/N 34-7570038 N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491 N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573 N32755Illinois Air Inc · Naperville, ILBuilt 1975 · S/N 34-7570049 N32776Hutchison Ross C · Olathe, COBuilt 1975 · S/N 34-7570052 N3277TBergson Enterprises Inc · Cedar City, UTBuilt 1995 · S/N 102 N327CABurbano Oscar Sebastian · Greensboro, NCBuilt 1979 · S/N 7970276 N327DFFlager Daryl L · Ottawa, KSBuilt 2000 · S/N 032748 N327JCPottier Michael · Dover, NHBuilt 1978 · S/N 28R-7803266 N327PZMcmage Aviation LLC · Grosse Pointe Park, MIBuilt 2005 · S/N 1507 N32812Rottinghaus Kelly A · Dundee, MSS/N 34-7570056 N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245 N32863International Air Services Inc Trustee · Carson City, NVS/N 34-7570062 N32873Blundell Joseph B III · Belleville, ARBuilt 1975 · S/N 34-7570064 N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N32959Hill Ryan D · Fresno, CAS/N 34-7570069 N32999Mil2atp Inc · Pikeville, NCBuilt 1975 · S/N 34-7570071 N329JSHc Rec LLC · Georgetown, KYBuilt 1979 · S/N 250236 N32CDN32cd Aviation Services LLC · Aptos, CABuilt 2005 · S/N 1521 N32CEMiller David J · Naperville, ILBuilt 1983 · S/N 25-0747 N32DGRous LLC · Fredericksburg, VABuilt 1987 · S/N 25-1128 N32DLLarson David W · Palmer, AKBuilt 1966 · S/N 1009C N3300AAdams Air & Sea Inc · Wilmington, DEBuilt 1969 · S/N 337-1094 N33012Leon Hinkle LLC · Fort Ashby, WVBuilt 1975 · S/N 34-7570072 N3306QTwin G Aviation LLC · Charlotte, NCBuilt 1977 · S/N 28R-7703100 N33071Krogstad Bruce H · Milwaukee, WIBuilt 1975 · S/N 34-7570082 N330LCDe Witt Luba Owner Trustee · Fort Lauderdale, FLBuilt 1980 · S/N P3370352 N33144Weather Modification LLC · Fargo, NDBuilt 1975 · S/N 34-7570094 N33156Bchr Aviation LLC · Boerne, TXBuilt 1975 · S/N 34-7570096 N3315VWirth Nicholas · Lake Geneva, WIBuilt 1977 · S/N R1722248 N331KWHeritage Academy Inc · Monterey, TNBuilt 1963 · S/N 3360026 N331VRaptor Airmotive LLC · Poplar Grove, ILBuilt 1978 · S/N 347870340 N3328MHidley Robert W · Oneida, TNBuilt 1977 · S/N 28R-7803165 N33303Kowalchyk Aviation Management LLC · Jasper, GAS/N 34-7570102

Back to AD 81-13-10 R1