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.
N836AKOld City Helicopter Sales LLC · Saint Augustine, FLN836ATDot Aviation LLC · Wilmington, DEN836CPCivil Air Patrol · Maxwell Afb, ALN836CRInbody Matt A · Derby, KSN836DBR&L Sales LLC · North Vernon, INN836DSLima Hotel Aviation LLC · Mooresville, NCN836FSSmart01 LLC · Kissimmee, FLN836KTAirhawks Flying Club · Eastsound, WAN836RMRegistered aircraftN836SPArmadillo Too LLC · Owensboro, KYN836TAFonnesbeck Robert R · Providence, UTN836TBEast Of Nowhere Aviation LLC · Highland, UTN8370CFigueroa Daniel · Dorchester, MAN8370PDonovan Patrick D · Troy, MON8370RYandik Stephen E Jr · Hudson, NYN8370WTaylor Tmothy P · Watford City, NDN8371CEmerald City Aircraft Leasing Inc · Port Orchard, WAN8371VPrairie Thermals LLC · Brookings, SDN8371WDavis Kyle G · Weatherford, TXN8371YAstro Star Aviation Inc · Niles, MIN8372CMarino Robert · Little Neck, NYN8372GSpitzer Helicopter LLC · Woodland Hills, CAN8372HEmerald City Aircraft Leasing Inc · Port Orchard, WAN8372LRed Sky Aviation LLC · Livermore, CAN8372RNovember Alpha LLC · Dover, DEN8373CFinley Aviation LLC · Bethel Park, PAN8373DGolden Wings Aviation Inc · Brandenburg, KYN8373EBabkin Aleksander A · Conyers, GAN8373KTorba Jacob · Citrus Heights, CAN8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeN8373PZeller Ryan P · Reno, NVN8373VSeidler Marlyn L · Underwood, NDN8373WAmplified Aviation LLC · Cannelburg, INN8373YArcher Assoc LLC · Ashburn, VAN83741Lenoir Dennis E · Cut Bank, MTN8374LGeneral Aviation LLC · Henderson, NVN8374PFreeman James T · Elizabeth City, NCN8374TCarlos Sean N · Togiak, AKN8374WMartin Rebecca · Bothell, WAN8375CHammett Jeb Stuart · Monroe, LAN8375PGores Thomas J · Franklin, WIN8375RCarlton John B · Lenoir, NCN8375WSingh Harbans · Las Vegas, NVN8375YSimmons John William · Ocala, FLN83763Stingerpower Inc · San Jose, CAN8376LPray Aviation Inc · Augusta, KSN8376PBeyl Steve W · Saint Croix Falls, WIN8376RRegistration Pending · Wshngtn Ct Hs, OHRegistration pendingN8376WSale Reported · Crystal, MNSale reportedN8376YScharfenberg Charles · Maquon, IL
Back to AD 87-10-06 R1