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.
N8597PIsbell James R · Denison, TXN8597VSitta Donald C · Farmington, NMN8597YTaylor Douglas S · Fairfield, CAN8598DBurkhart Verlus L · Fairmont, MNN8598YGulf Coast Aviation LLC · New Orleans, LAN8599NScott Lauren M · Lighthouse Point, FLN8599VObx Airplanes LLC · Manteo, NCN8599WHackett Dean · Lake City, FLN859ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYN859CPN859cp LLC · Boynton Beach, FLN859MHHarrington Mark · West Milford, NJN859RAThree Green Inc · Wilmington, DEN859RGVan Bortel Aircraft Inc · Arlington, TXN859RKRisk Indemnification Professionals LLC · Anchorage, AKN859SCFf22 LLC · Scottsdale, AZN859SPJet Air Inc · Iowa City, IAN859TRaven Aviation LLC · Lexington, KYN85ALLee Donald Robert · Talkeetna, AKN85BHRoholt Philip C · Canton, OHN85BKBkv Aero Squadron LLC · New Port Richey, FLN85BMMc Crorie Robert A · Sequim, WAN85BRPalmer Travis S · Maupin, ORN85BWSayler Nathan T · Valley City, NDN85CSeay Edward A · Signal Mountain, TNN85CJLadd Franklin W · Oneida, TNN85CTAerobsession LLC · Erie, CON85DGGarrison Stephen L · Johnson City, TNN85DJRegistered aircraftN85DLDelta Lima Inc · Justice, WVN85ELRedtail Air LLC · Laporte, CON85EZLarock Ronald R · Fairhaven, MAN85FTSpain Ryan D · Shelbyville, ILN85FZZeller Francis J · Rosamond, CAN85GJScifers John W · Sarasota, FLN85GPRay Hardee · Dupont, WAN85HGJwp Group LLC · Long Island, MEN85HMArmey Andrew D · Fresno, CAN85HYGades Allen L Trustee · Montevideo, MNN85JBBurke Jonathan · Berkeley, CAN85JFFleeman Joseph R · Lawrenceburg, TNN85JWWhittington Robert W · Blackwell, OKN85KWN85kw LLC · Avon, INN85LEThalman Joseph B · Kenosha, WIN85LSScholten Calvin B · Lakeland, TNFirst renewal noticeN85LVAllen Gregory D · Wray, CON85LWPlanenuts LLC · Boulder, CON85MANorthcutt Allan C · Broomfield, COFirst renewal noticeN85MBBradley Max T II · West Plains, MON85MDPair Chris X · Fletcher, NCN85MPPitman Marvin L · Harrah, OK
Back to AD 87-10-06 R1