AD 87-10-06 R1
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
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.
N8440WPensa Way Inc · Pensacola, FLN84412Sohini Vinod Rai · Lufkin, TXN8441AAerolease LLC · Wilmington, DEN8441CCirrus Aviation Inc · Easton, PAN8441HEuroair Consultants LLC · Vero Beach, FLN8441LG1 Aviation LLC · Ocala, FLN8441MAmick David E · Elizabethtown, PAN8441WGeaney Kacy B · Alturas, CAN84422Dhr Investments LLC · Beaumont, TXN84429Avz Aviation Of Tennessee Inc · Knoxville, TNN8442ADillehay David · League City, TXN8442DFlymart Inc · Hastings, FLN8442HWhited Grant Trustee · Petaluma, CAN8442LChappell Johnathan · Santa Barbara, CAN8442PCbfd LLC · Northampton, PAN8442RBandon Aviation LLC · Bandon, ORN8442WInspire Aviation LLC · Magnolia, TXN84434Russell Aerial Photography Inc · Edgewater, FLN8443PLeggett Marjy A · Pasco, WAN8443RKor Aviation LLC · Piedmont, SDN8443WFew Tyus S · Roanoke Rapids, NCN84440Yankee Charlie LLC · Melbourne, FLN84449Eskridge Jonathan L · Rio Rancho, NMN8444BLutz Christine A · Acton, CAN8444DEtheredge Mark · Pell City, ALN8444JHeartland Ag Aviation LLC · Lancaster, KSN8444LRiley David R · Baltimore, MDN8444SVertex Aviation Services LLC · Burlington, WAN8444WShowalter Robert B · Orlando, FLN8444YBeacon Aviation Flight Services LLC · Rogers, ARN84455Green Castle Aero Club · Oxford, IAN84456Warbirds East Inc · Fairhope, ALN84459Maddox Glen E · Bushnell, FLN8445ADowntown Goldsmith & Engraving · Deland, FLN8445BStarnes Robert · Vandervoort, ARN8445DRowell Joe William · Indian Trail, NCN8445GStauffer David R · Boise, IDN8445HOracle Aviation LLC · Omaha, NEN8445LCurtis Bruce G · Eugene, ORN8445RTakeoff Power Aviation And Media Solutions Inc · San Juan, PRN8445SWifa (Washington International Flight Acad) LLC · Gaithersburg, MDN8445XCrossbrook LLC · Willoughby, OHN84465Double Bridges Aviation LLC · Enterprise, ALN84467Lewin Robert · Essex Fells, NJN84468Whiting Joseph · Roy, UTN8446DMcmaster James R II · Bath, PAN8446RKonyndyk John R · Muskegon, MIN84473Lawrence Blake C · Monument, ORN84474Young John R · Rockland, MAN84478Shg Holdings LLC · Greer, SC
Back to AD 87-10-06 R1