Skip to content

Registered aircraft · 81,728

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-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471 N3216FPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670009 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032 N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033 N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030 N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031 N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032 N3217WNorth Anthony B · Bloomfield, CTBuilt 1965 · S/N 32-19 N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158 N32181Weaver James D · Montgomery, INBuilt 1974 · S/N 28-7515088 N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218MAthol Aggregate LLC · Athol, IDBuilt 1947 · S/N 12-1881 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092 N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093 N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036 N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034 N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035 N3219FTop Flight Detail LLC · Middlebury, INS/N 670012 N3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIBuilt 1976 · S/N 18-7709030 N3219PShoot LLC · River Ridge, LAS/N 14243 N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132 N321ABAmbrosini Alfred F · Connellsville, PABuilt 1979 · S/N 14523 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321BCGeorge Nathan V · Dardanelle, ARS/N 370-95 N321BDFoskett James Jerome · Pewaukee, WIBuilt 1975 · S/N BH120/292 N321BYStates Thane · Boise, IDBuilt 2008 · S/N 40337 N321BZJakes Air Service LLC · Holt, FLBuilt 1999 · S/N 22968 N321CGSuper 700 LLC · Robbinsville, NJBuilt 1979 · S/N 61P07097963341 N321CKFairwinds Aviation LLC · Goldsboro, NCBuilt 2004 · S/N 40.414 N321CUStambaugh Scot D · Bainbridge Island, WABuilt 2004 · S/N 019 N321DDoyle Charles J · Sequim, WABuilt 1974 · S/N AA1B0321 N321DKTwi Air LLC · Picayune, MSBuilt 1998 · S/N 18280311 N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DPDelta Papa LLC · Henderson, NVBuilt 1979 · S/N 32-7940032 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321EFRengel Richard J · Tustin, CAS/N 1900 N321EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12622 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321FSUtah State University · Logan, UTBuilt 2004 · S/N 40.384 N321GBTwisted Roots Aviation LLC · Chesterton, INBuilt 1964 · S/N 28-10413 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158 N321GW321gw LLC · Chico, CABuilt 1998 · S/N 18280209 N321HMMusser Harold R · Cody, WYBuilt 2010 · S/N 3109 N321HWVan Andel Lambert J Jr · Coopersville, MIBuilt 1998 · S/N 18280264 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321JECapital Affairs West LLC · Helena, MTBuilt 2004 · S/N 40.374

Back to AD 81-18-04 R2