Registered aircraft · 81,733

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.

N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066 N358SPIscovich Angel L · Santa Barbara, CABuilt 1997 · S/N 22468 N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858 N358TWTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 172S9751 N358VAChapman James H · Mebane, NCBuilt 2013 · S/N 25218 N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545 N3590WAgoston Thomas M Trustee · Liberty Twp, OHBuilt 1966 · S/N 32-485 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591MScheibe Marvin E · Wooster, OHBuilt 1947 · S/N 12-2437 N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108 N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704 N3592AKyle Allyn B · Snohomish, WABuilt 1953 · S/N 18-3022 N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647 N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692 N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705 N3592WFoothills Aviation Inc · Pickens, SCBuilt 1966 · S/N 32-488 N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693 N3593WGriffin Julie A · Locust Grove, GABuilt 1966 · S/N 32-489 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N3594JWxs Flying LLC · Mesa, AZS/N 32-7840095 N3594MThacker William E · Chenoa, ILS/N 12-2439 N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694 N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553 N3595WStanley Shawn G · Lorton, VABuilt 1966 · S/N 32-491 N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388 N3596ASjostedt Brad D · Cordova, AKBuilt 1953 · S/N 18-3026 N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648 N3596WAbdelqader Hamza Faris · Beaufort, SCBuilt 1966 · S/N 32-492 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N3597AN3597a LLC · Rockford, MIS/N 18-3027 N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601 N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649 N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555 N3598MOlmstead Dorothy E · Talkeetna, AKBuilt 1947 · S/N 12-2444 N3598WSwiss Eagles Inc · Las Vegas, NVBuilt 1966 · S/N 32-495 N3599AReed John S · Wasilla, AKBuilt 1953 · S/N 18-3011 N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238 N3599ZBell Mark W · Soldotna, AKS/N 18-7393 N359ACRunde Warren N · Concord, NHBuilt 2009 · S/N 1454-2009 N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020

Back to AD 81-18-04 R2