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.

N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77 N25062Stratton James P · Lubbock, TXBuilt 1979 · S/N 38-80A0026 N2506GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 38-79A0547 N2506LColumbus State Community College · Columbus, OHBuilt 1979 · S/N 38-79A0740 N2506WHeiss William R · Watkins, COS/N MC-165 N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77 N2507Wagar Dennis Murphy · Marion, MTBuilt 2022 · S/N 5330 N2507AMann Robert M · Royal Oak, MIBuilt 1978 · S/N 38-78A0722 N2507DMurphy Robert Joseph · Galveston, TXS/N 38-79A0344 N2507KLabonte Stephen M · Gilford, NHBuilt 1968 · S/N 217 N2507MEller Ralph E · Wasilla, AKBuilt 1946 · S/N 12-1005 N2507TCoscarelli Guillrtmo H · Wailuku, HIS/N 914 N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190 N2507ZZawada John R · Wht Sphr Spgs, MTBuilt 1999 · S/N 55 N2508WBas Part Sales LLC · Greeley, COS/N MC-166 N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78 N25091Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0029 N25096Green Air LLC · Novato, CAS/N 961 N2509AEagle Aviation LLC · Benton, KYBuilt 1978 · S/N 38-78A0724 N2509DLong Joel A · Clinton, MOBuilt 2000 · S/N 22501 N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870 N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639 N2509XOrsippus Management LLC · El Dorado Hills, CAS/N 951 N2509ZKovach Kim A · Ocala, FLS/N 333-77 N250AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13265 N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425 N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931 N250CHSorrell Jeffrey R · Winter Haven, FLS/N 250 N250CRTruflight Leasing LLC · Owasso, OKBuilt 2023 · S/N 1336 N250DBJordan J Michael · Arlington, GABuilt 1980 · S/N 1 N250DJRhoades James H · Pleasanton, CABuilt 1980 · S/N 0003-80 N250DSLanger Paul Hubert · Gainesville, TXBuilt 1996 · S/N 250 N250ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608250 N250EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 2020 · S/N 18283106 N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148 N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100 N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496 N250JBGuy Jeffrey · Centerburg, OHBuilt 1981 · S/N A-109 N250JFSnapp Michael D · Portland, ORBuilt 1997 · S/N 644-320-389 FB N250JGGross Jeffrey M · Bastrop, TXBuilt 2005 · S/N 81185 N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936 N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393 N250MPray Aviation Inc · Augusta, KSS/N TD-625 N250MALc Flyers LLC · Monument, ORBuilt 2003 · S/N 2243 N250MGAkin Kent Trustee · Midland, TXBuilt 1980 · S/N 0005-80 N250MPJohanson Jason · Groveland, CAS/N 010 N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681

Back to AD 81-18-04 R2