Registered aircraft · 72,010

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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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.

N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111 N3871KDesert Wind Wings LLC · Mesa, AZBuilt 1948 · S/N 3571 N3871MProut Paul D · Eveleth, MNBuilt 1947 · S/N 12-2886 N3871RFly Vermont LLC · Swanton, VTBuilt 1970 · S/N 28-5846 N3871TSzd Property Management LLC · Oceanside, CABuilt 1967 · S/N 28R-30195 N3871XJohnson Roger L · Broken Arrow, OKBuilt 1967 · S/N 168 N38725Maynard Geoffrey · New Marlborough, MABuilt 1977 · S/N 32R-7780465 N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972 N3872TTucker Zane Griffin · Albany, ORBuilt 1967 · S/N 28R-30196 N3872URegistered aircraftBuilt 1981 · S/N M-2239 N3872XBehrens Bros Aviation LLC · Gerald, MOBuilt 1967 · S/N 170 N3872ZHale Mitchell D · Chugiak, AKBuilt 1961 · S/N 18-7657 N38733Lauren Erick · Hollister, CABuilt 1977 · S/N 28-7790580 N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581 N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973 N3873TDerby City Aviation LLC · Vero Beach, FLBuilt 1967 · S/N 28R-30197 N3873WBrault David M · Lake Stevens, WABuilt 1966 · S/N 32-819 N3873ZSchok Richard N Jr · Fairbanks, AKBuilt 1961 · S/N 18-7661 N38746Campbell David A Trustee · Bolivar, MOBuilt 1977 · S/N 32R-7780466 N38749Epperson Matthew · Moraga, CABuilt 1977 · S/N 32R-7780467 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 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 N387JVBonura Rocco F Jr · Perkinston, MSS/N 24139

Back to AD 87-10-06 R1