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.

N5294XCarrigan Roy K · Oak Grove, MNS/N 2220 N5294ZMorpeth Dorinda · Fortson, GABuilt 1961 · S/N 22-8994 N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642 N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644 N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824 N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559 N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941 N5295ZFawcett Debra K · Baraboo, WIBuilt 1961 · S/N 22-8995 N5296BRobertson Ca · Phoenix, AZS/N 1158 N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050 N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337 N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510 N5296TGq Aviation LLC · Cherry Hill, NJBuilt 1972 · S/N 34-7250244 N5296ZSouthern Sky LLC · Henderson, NVBuilt 2002 · S/N 172S9241 N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159 N5297EAtd Pilot Training LLC · Kansas City, MOBuilt 2002 · S/N 172S9242 N5297GChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9243 N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599 N5297MAllard John R · Circleville, OHS/N 15284518 N5297PMoretti Anthony · Deming, NMBuilt 1958 · S/N 24-338 N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511 N5297TMid Atlantic Air Museum · Reading, PABuilt 1972 · S/N 34-7250245 N5297WTausch Eddie W · Port Aransas, TXS/N 28-348 N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022 N52987Lewis Nathan A Trustee · Watsonville, CABuilt 1978 · S/N 177RG1323 N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500 N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758 N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051 N5298NJ3m Airops LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9244 N5298PCroasdale Terry Lee · Modesto, CAS/N 24-339 N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512 N5298SSix Ten Ventures LLC · Grand Prairie, TXBuilt 2002 · S/N 172S9246 N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349 N52990Hurley Drew M · Port Orange, FLBuilt 1978 · S/N 177RG1324 N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654 N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501 N5299LSerafini Ronald S · Murphy, NCS/N 28-4601 N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744 N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350 N5299ZWilliams Robert M · Red Hook, NYBuilt 1961 · S/N 22-8786 N529BGGreen Robert M · Mechanicsville, MDBuilt 2024 · S/N 42272 N529BHVanhouten Philip D · Wallkill, NYS/N 529W N529CANeufeld Don I · Fairview, OKS/N 17269104 N529CMHill Thomas Gerald · Port Tobacco, MDBuilt 2010 · S/N 40700 N529CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843925 N529DARegistration Pending · Travis Afb, CARegistration pendingBuilt 2020 · S/N 2881423 N529ERPs N529er LLC · Green Bay, WIBuilt 2002 · S/N 172S9111 N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356

Back to AD 81-18-04 R2