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.

N280FGFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496525 N280FSAirflight LLC · Wilmington, DEFirst renewal noticeBuilt 2003 · S/N 2094 N280GACavanaugh Flying Service Inc · Minden, NEBuilt 1998 · S/N 2009825F N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733 N280HRMussen Gary L · Exeter, CABuilt 1995 · S/N 32 N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620 N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498 N280JSStefanini Joseph M · Akron, OHS/N 1510 N280LASeipp Stephen C · Laurel, DEBuilt 1999 · S/N 2085 N280MMrr Spraying LLC · Shelby, MTFirst renewal noticeS/N 749 N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004 N280MGM&M Charter LLC · Mountville, PABuilt 1978 · S/N 1135 N280MHGulf Coast Helicopters Inc · Pearland, TXBuilt 1988 · S/N 2022 N280MLLundy Michael · Stephenville, TXS/N 2032 N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450 N280NARohner Harlan G · Willmar, MNS/N 2058 N280PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10834 N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230 N280QCasey Aviation Inc · Burke, TXBuilt 1975 · S/N 1011 N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070C N280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803 N280SHRottor Aviation LLC · Jasper, INBuilt 2003 · S/N 2095 N280SMAirpark Aviation LLC · Manchester, NHBuilt 1999 · S/N 2083 N280SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12432 N280TKrengel Lawrence E · Marengo, ILBuilt 1953 · S/N 18-2394 N280TCNobles Gary D · Fairview, TXS/N 28-21227 N280UOhio University · Athens, OHBuilt 2003 · S/N 172S9464 N280WLWalloon Air LLC · Oakwood, OHBuilt 2025 · S/N 3450 N280WRBeacon Aviation Flight Services LLC · Rogers, ARBuilt 1977 · S/N 1108 N280YSCrabtree Martin L · Sedalia, MOS/N BING-1 N28103Hawksyntketics LLC · Jacksonville, FLS/N 78-31150 N2810MDavis Ronald L Jr · Soldotna, AKBuilt 1946 · S/N 12-1263 N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810 N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137 N28110Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496513 N28114Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496514 N28115Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496515 N28117Olson Alan A · Garnet Valley, PABuilt 2011 · S/N 80188 N2811GNablo Dustin · Haddam Neck, CTBuilt 1967 · S/N 170 N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101 N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296 N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66 N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804 N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812 N2812VKennison Daniel J · Las Vegas, NVFirst renewal noticeS/N 1084 N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212 N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805 N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052 N28138Todd Jared · Victoria, TXBuilt 1977 · S/N 78-31142 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813

Back to AD 81-18-04 R2