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.

N44176Taylor Wilbur J Jr · Oro Valley, AZBuilt 1974 · S/N 28-7415596 N4417AMiller Edward L · Santa Rosa, CABuilt 1984 · S/N F-1506 N4417BWilkins Raymond E · Osceola, IAS/N F-1507 N4417EDeaton David B · De Berry, TXBuilt 1985 · S/N F-1022 N4417HBalunek Konrad K · Avon, OHBuilt 1986 · S/N F-1516 N4417JPalmatier Seth · Chandler, AZBuilt 1967 · S/N 28-22814 N4417NMeis Joseph M · Elgin, NES/N F1509 N4417PRegistered aircraftS/N F1510 N4417QBaldwin Eileen J · Shady Cove, ORS/N F1511 N4417TBimini Bullet LLC · Lakeland, FLBuilt 1972 · S/N 32-7200021 N44189Lane Robert C · Calico Rock, ARBuilt 1974 · S/N 28-7415598 N4418FMcclure John M · Fairbanks, AKS/N F1514 N4418JS B Enterprise LLC · Marshall, TXBuilt 1967 · S/N 28-22815 N4418MFeder Trent T · Madelia, MNS/N F1515 N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166 N4418VMiddleton Mace D · Tulia, TXS/N F-1520 N4418YMilano Vito R Trustee · Middletown, MDS/N F-1521 N4418ZHigh Wind Aviation Service LLC · Ludlow, VTBuilt 1968 · S/N 18-8753 N44191C H Aviation Services Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N 28-7690330 N44192Steere George O Jr · Chepachet, RIBuilt 1974 · S/N 28-7405226 N44193Brekhus Scotti · Cheyenne, WYBuilt 1974 · S/N 28-7405227 N44195Guthrie Aircraft Inc · Wadsworth, OHBuilt 1974 · S/N 28-7405228 N4419JN2893e LLC · Reno, NVBuilt 1965 · S/N 28-2641 N4419PAircraft B52 LLC · Lewes, DEBuilt 1991 · S/N 2209 N441ACAero Champ LLC · Orlando, FLS/N 401-97 N441AMFussell Aviation LLC · Mcrae-Helena, GABuilt 1966 · S/N 28-3688 N441APSisk Jared · Odessa, MOBuilt 1991 · S/N 1904 N441BGAwa Aviation LLC · Okeechobee, FLBuilt 2011 · S/N 13223 N441BJB & J Flying Service · Etters, PABuilt 2004 · S/N 10528 N441BMMillsap Ted I · Redding, CAS/N 28-22816 N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441 N441CHRegistration Pending · La Conner, WARegistration pendingBuilt 2002 · S/N 10012 N441CKWinters John H · Birch Run, MIBuilt 1975 · S/N 28R-7535314 N441CMBtj Adventure Co LLC · Wilmington, DEBuilt 2025 · S/N 3462 N441DEWhirld Helicopters Inc · Sevierville, TNBuilt 2006 · S/N 11249 N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391 N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691 N441DRDakota Rotors LLC · Custer, SDFirst renewal noticeBuilt 2004 · S/N 10375 N441EDGold Prop Aviation LLC · Auburndale, FLBuilt 1985 · S/N 327 N441EKSkf Holdings LLC · Breckenridge, TXBuilt 2002 · S/N 1190 N441ELRegistration Pending · Caledonia, WIRegistration pendingBuilt 2014 · S/N 90586 N441ERVeve Jesus Vila · Mayaguez, PRBuilt 2005 · S/N 172S10060 N441FLJustice Carrie · Plano, TXBuilt 1971 · S/N 28-7125230 N441HGGeorgia Aviation Authority · Eastman, GABuilt 1995 · S/N 4496003 N441MA9k Air LLC · Newark, DEBuilt 2021 · S/N 4496526 N441MRHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2003 · S/N 1329 N441NCCharlie Papa LLC · Van Nuys, CABuilt 2005 · S/N 10621 N441PFBusy Bee Helicopters LLC · Dover, DEBuilt 2005 · S/N 1522 N441PRHuntingdon Valley Helicopter LLC · Wilmington, DEBuilt 2004 · S/N 10310 N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278

Back to AD 81-18-04 R2