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.
N631BWHaase Eric J · Woodland Hills, CAN631CPCivil Air Patrol · Maxwell Afb, ALN631DMPlehn John C · Sandy Valley, NVN631DPHeritage Rotors LLC · De Leon Springs, FLN631FLMiller William H · Blue Mound, ILN631FTFlorida Institute Of Technology · Melbourne, FLN631KYHanson Anthony R · Ozark, ALN631MARexair Aircraft LLC · Naples, FLN631NDUniversity Of North Dakota · Grand Forks, NDN631PCPiper Aircraft Inc · Vero Beach, FLN631RVMichigan Tail Draggers LLC · Macomb, MIN6320CHeme Flying LLC · Lewisville, NCN6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN6320JJns Corp · Wilmington, DEN6320QLucas Warr & White LLC · Florence, SCN6320RGehr Garner J · Eustis, FLN6321JPrecision Aircraft Service LLC · Staples, MNN6321QDonesky Orville B · Cleveland, TNN6321TTwo One Tango LLC · Waynesboro, PAN6321YHallstein Roy M · San Jose, CAN6322JBaus Mark L · La Crosse, KSN6322NThelander Edwin · Bristol, MEN6323Spence Vincent Anthony · Arlington, TNN6323JYoung Troy D · Vernon, TXN6323NRay Raymond Heath · Louisville, KYN6323PJeffs Andrew S · Phoenix, AZN6323RSeigel Virginia L · Havre, MTN6323WMedicine By Design Inc · Miami, FLN6324PPorter John A · Cody, WYN6324QTymoshenko Yuriy · Clearwater, FLN6324TRegistered aircraftN6324VBranham Chris R · Anchorage, AKN6325DCox Ronnie L · Whitesburg, GAN6325JBantle Flyers LLC · North Chesterfield, VAN6325LStearns Edwin Ben Jr · Eloy, AZN6325RVaught Janet M · Creedmoor, NCN6326CBridges Gerald Lloyd · Chelsea, MIN6326EKevin Formica Inc · Boca Raton, FLN6326FAirtime Holdings LLC · Charleston, SCN6326QMontpelier Gary L · Bushnell, FLN6326RBlancett-Maddock David D · Kailua Kona, HIN6326WKipkurui Stephen · Fort Worth, TXN63273Hlavinka Terrance J · East Bernard, TXN63279P & H Air Inc · Overland Park, KSN6327PSunspot Investment Corp · Marathon, FLN6327QHarrod Tracey Lynn · Bedford, KYN6328JWildflower Remedies LLC · Millersburg, OHN6329JBeavers Danny G · San Antonio, TXN6329PKhan Adam Iqbal Ahmed · Sanger, TXN6329QRegistration Pending · Zavalla, TXRegistration pending
Back to AD 87-10-06 R1