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.

N3873WBrault David M · Lake Stevens, WABuilt 1966 · S/N 32-819 N3873ZSchok Richard N Jr · Fairbanks, AKBuilt 1961 · S/N 18-7661 N38749Epperson Matthew · Moraga, CABuilt 1977 · S/N 32R-7780467 N3874MGott Michael · Fairbanks, AKBuilt 1947 · S/N 12-2785 N3874PPearson Joshua J · Unionville, MOS/N 22-3567 N3874TSmith Albert G Jr · Lake Jackson, TXBuilt 1967 · S/N 28R-30199 N3874WSplit Oak Contracting Inc · Williamson, GABuilt 1966 · S/N 32-820 N3874XTr Flying Service LLC · Milan, MNBuilt 1967 · S/N 173 N3874ZSlinkard Justin W · Bakersfield, CABuilt 1961 · S/N 18-7734 N38752Leblanc Richard · Mclean, VABuilt 1977 · S/N 32R-7780468 N3875MSky Ad Inc · Greenwich, CTBuilt 1947 · S/N 12-2786 N3875PLonnevik Dennis F · Bigfork, MTBuilt 1955 · S/N 18-4701 N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975 N3875TMichael Jin · Renton, WABuilt 1967 · S/N 28R-30200 N3875XTate Maurice J · Hope Valley, RIS/N 174 N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999 N3876PBreen George R · East Falmouth, MABuilt 1956 · S/N 18-4702 N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976 N3876WSteele Kyle Z · Acworth, GAS/N 32-822 N3876XFlying Weenie LLC · Henderson, TXBuilt 1967 · S/N 175 N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116 N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117 N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181 N3877PBranson Derrick · Seward, AKBuilt 1955 · S/N 18-4703 N3877ZAlsworth John H · Anchorage, AKBuilt 1961 · S/N 18-7668 N38786Johnson David M · South Deerfield, MABuilt 1977 · S/N 28-7790588 N3878TRoach Keith E · Chester, SCBuilt 1967 · S/N 28R-30203 N3878ZWorrell Trevor S · Anchorage, AKBuilt 1961 · S/N 18-7672 N3879MMcgowan Patrick Joseph · Troutdale, ORBuilt 2010 · S/N 81094 N3879PZimmer Chris P · Upham, NDBuilt 1955 · S/N 18-4705 N3879RFox Pond Farm · Indian Trail, NCFirst renewal noticeBuilt 1970 · S/N 28-5851 N3879TDupuis Kevin P · Waddell, AZBuilt 1967 · S/N 28R-30204 N3879WSale Reported · Texarkana, TXSale reportedBuilt 1966 · S/N 32-825 N3879ZNelson Chad A · Buffalo, SDBuilt 1961 · S/N 18-7677 N387AFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2006 · S/N 172S10387 N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287 N387DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12652 N387JAAdams John W · Glennallen, AKBuilt 1987 · S/N 1986-A2 N387JVBonura Rocco F Jr · Perkinston, MSS/N 24139 N387LCCooper Gerald W · Kennewick, WABuilt 2000 · S/N 54821 N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387 N387RCrossley Eber G · Farmington, NMBuilt 2004 · S/N EGC-01 N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284 N387XDowns Rodney A · Anchor Point, AKFirst renewal noticeBuilt 1976 · S/N 7024C N38804H And R Aviation LLC · Jonesboro, ARBuilt 1977 · S/N 28-7790589 N38809Somerset Air Service Inc · Bedminster, NJBuilt 1977 · S/N 28-7725250 N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980 N3880TThoms Gregory S · Adkins, TXBuilt 1967 · S/N 28R-30206 N3880WSpecialized Communications · Smithsburg, MDBuilt 1966 · S/N 32-826 N38818Rogers Jason · Limerick, PABuilt 1977 · S/N 32R-7780475

Back to AD 81-18-04 R2