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.
N76172Rjd Flight LLC · North Canton, OHN7617DRunyan Colton C · Ashland, ALN7617FKeldahl William J · Copperhill, TNN7617JMilner Quinn D · Carbondale, ILN7617PSlack Don S · Stinson Beach, CAN7617VSoaring Utah Inc · Sandy, UTN7617WWhirl'D Helicopters Inc · Sevierville, TNN7618PJaton Bertrand F · Woodville, TXN7618SBraun Michael T · Oconomowoc, WIN7618WExaltium Aviation LLC · Baltimore, MDN7619FAinsworth Cavin · Fort Towson, OKN7619GMercer Aviators Inc · Princeton, WVN7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLN761AZAndover Flight School Inc · Andover, NJN761CAChristiansen Aviation LLC · Wilmington, DEN761CCHesston College Aviation · Hesston, KSN761CSParker Todd Steward · Kaysville, UTN761GSSaulsbury Greg F · Nash, TXN761LAIowa Lakes Community College · Estherville, IAN761RBBastin Robet J · Cadiz, KYN761WWilliams Richard G J · Labelle, FLN7620FRed 5 LLC · Kalispell, MTFirst renewal noticeN7620GDc Aero LLC · Ramona, CAN7620PSopwith James T · Sacramento, CAN7621EGrey Matter Inc · Valley Springs, CAN7621FMeier Scott F · Jupiter, FLN7621GCrewdawg Aviation LLC · Concord, NCN7621PMckusick Eileen D · Winooski, VTN7621SSmith Michael D · King George, VAN7621WAlexander Steven W · Kansas City, MON7622FAeronation Aircraft & Exotics LLC · Lewes, DEN7622GBell Sky Pilots Inc · Reedley, CAN7622JSkylink Aviation Inc · Florissant, MON7622LHowe Jamie W · Boynton Beach, FLN7622PGriffin Robert L Jr · Washington, NCN7622WBarnett Donald R · Atoka, TNN7623DBaker Donald A · Macedon, NYN7623GPlane Sane Aero LLC · Cary, NCN7623HCowan Drew Paul · Anchorage, AKN7623JWhite Jeffrey M · Carlsbad, CAN7623RAdamiak Jeffrey · Mount Laurel, NJN7623SKrejchik Daniel J · Portage, WIN7623WMidwest Heavy Construction LLC · Pleasant Hill, MON7624GAeroflight Flying Club Inc · Jackson, TNN7624JBriggano LLC · Mount Pleasant, SCN7624SHovey Gregg Beecher · San Diego, CAN7624WHartley Douglas R · Florence, ALN7625FHarbaugh Steven J · Riverside, CAN7625JHuebscher Attila · Flemington, NJN7625MMccowan Kenneth L · Kansas City, KS
Back to AD 87-10-06 R1