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.

N498LPN57kk LLC · Livingston, MTBuilt 2023 · S/N PX1520027 N498MALake Air Express LLC · Bettendorf, IABuilt 1998 · S/N 3246098 N498SPBmg Aviation Inc · Bloomington, INBuilt 1998 · S/N 172S8039 N498THInterstellar Vc LLC · New York, NYBuilt 1978 · S/N AA5A0611 N4990DThompson Darrel D · Toronto, SDBuilt 1980 · S/N 65638 N4990JEstes Aviation LLC · Vicksburg, MSBuilt 1968 · S/N 28R-30746 N4990LCc Aero Services LLC · Bullard, TXBuilt 1967 · S/N 28-4364 N4990PCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1967 · S/N 18-8564 N4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842230 N4990WKennedy Terry P · Kingman, AZBuilt 1977 · S/N 14310 N4990ZHanson Ethan C · Blanchard, NDBuilt 1961 · S/N 22-8598 N49916Clemence Richard · Southbridge, MABuilt 1978 · S/N 15281392 N4991LStrickland Sterling S · Sammamish, WABuilt 1967 · S/N 28-4381 N4991NSage Daniel M · Girdwood, AKS/N 18-872 N4991ZSenneff James L · Clarence, NYBuilt 1961 · S/N 22-8599 N4992JBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 28R-30748 N4992LGrove City Aviation LLC · Mercer, PABuilt 1967 · S/N 28-4365 N49931Monterey Bay Aviation Inc · Watsonville, CABuilt 1978 · S/N 15281402 N4993LEagerton Aviation LLC · Florence, SCS/N 28-4366 N4993PHatch George R · Avon, MABuilt 1967 · S/N 18-8577 N4993WHamilton Robert A · Owensboro, KYBuilt 1977 · S/N 14313 N49940Jennings Dana B · Gates, ORBuilt 1940 · S/N 29 N49948Stuart George G · Maceo, KYBuilt 1975 · S/N AA5A-0046 N4994ELaforest David C · Hudson, MIBuilt 1978 · S/N 17271688 N4994JCrowe Justin L · Tompkinsville, KYS/N 28R-30750 N4994SSmith Thomas C · Norfolk, VABuilt 1970 · S/N 28R-35719 N4994ZAom Aircraft LLC · Wilmington, DES/N 22-8604 N49950Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15281410 N49952Mccarthy Robert W · Rockford, ILBuilt 1978 · S/N 15281412 N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501 N4995FSkorina Frank K · Walla Walla, WABuilt 1976 · S/N 28-7725040 N4995SNova Aero LLC · Ontario, ORBuilt 1970 · S/N 28R-35720 N4995ZBoyer James A · Lancaster, OHBuilt 1961 · S/N 22-8605 N4996JLee Matthew · Magnolia, TXBuilt 1968 · S/N 28R-30752 N4996LConverse Alan W · Garfield, KSBuilt 1967 · S/N 28-4369 N4996SChabrian Jerry W · Daytona Beach, FLBuilt 1970 · S/N 28R-35721 N4997PBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1967 · S/N 18-8580 N4997ZRoyal Flush Farms LLC · Davey, NEBuilt 1961 · S/N 22-8607 N49988Johnnys Air Service LLC · Senoia, GABuilt 1978 · S/N 15281428 N4998GOdenbach Eric J · Eureka, SDBuilt 1974 · S/N 28-7425218 N49993Starr LLC · Superior, WIBuilt 1978 · S/N 15281431 N49994Mdr Rental Corp · Ann Arbor, MIBuilt 1978 · S/N 15281432 N4999CKipp Russell · Meadow, TXBuilt 1989 · S/N 1067M N4999FHarrington Jennifer L · Minneapolis, MNBuilt 1976 · S/N 28-7715091 N4999LKnox Mark M · Thornton, PABuilt 1967 · S/N 28-4371 N4999SStaples Chad V · Efland, NCBuilt 1970 · S/N 28R-35724 N4999ZMendoza Justin · Paso Robles, CABuilt 1961 · S/N 22-8544 N499CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12510 N499CRAce Tomato Company LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4858 N499DCConrad David J · Wausau, WIBuilt 2011 · S/N 02.1219

Back to AD 81-18-04 R2