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.
N63SASky View Aviation LLC · Lenoir, NCN63SMMoore George L · Spring Hill, KSN63SPGraves Klaric Carl · Fate, TXN63TBSievers James E · Verdi, NVN63TXKilly James · Littleton, CON63VLPulsar Investments Inc · Scottsdale, AZN63WALariscey Adam · Lyons, GAN63WFThompson Kevin J · Three Rivers, CAN63WMSmith Russell M · Bokeelia, FLN63WPRenno Aero LLC · Ann Arbor, MIN63WTRodencal Richard · Wisconsin Rapids, WIN64001Alpha One Aviation LLC · Corona, NYN64007Baugh Tommye R · Star City, ARN6400PRiegel Frederick E · Houston, OHN6400SRegistration Pending · Salida, CORegistration pendingN6400UAudetat Thomas Jr · Marana, AZN6400VFearon Kenneth M · Sidney, OHN6400WRegistration Pending · Los Osos, CARegistration pendingN6400YAztec Flyers LLC · Zephyrhills, FLN64012Jin Jin Aviation LLC · Anchorage, AKN64014Maynor Robert B · Mansfield, LAN64016Ponderosa Aviators LLC · Baker, MTN64017Pilots Today Inc · Berlin, MDN6401JMccarthy J Patrick · Pleasanton, CAN6401QHunter Donald J · Scottsdale, AZN6401RNorthern Prairie Sky LLC · Erskine, MNN6401UBlue Sky Aviation Adventures LLC · St George, UTN6401VGdl Aviation LLC · Lincoln, NEN6401YBudd Richard E · Brooksville, FLN64020Bend Aircraft Mechanics LLC · Bend, ORN64023Rawson Aviation LLC · Collinsville, OKN64027Snyder Brent R · Dallas, TXN6402QMooney Mooney Mooney LLC · Gig Harbor, WAN6402UMccleave Thomas · Everett, WAN6402VG&M Aircraft Inc · Wheat Ridge, CON64034State Of Louisiana · Baton Rouge, LAN64035Loomis Darwin · Mooreland, OKN6403EGultch Dale R · Brookfield, WIN6403JDog House Aviation LLC · Houston, TXN6403PDiemand Larry L · Mentor, OHN6403QMiller Fred J · Sahuarita, AZN6403VVista Aviation Inc · Pacoima, CAN6403WDanford Scott M · Chickamauga, GAN64040Golding Donald J · Tucson, AZN64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeN64045Walker Robert · Chula Vista, CAN64046Biesecker Michael Gary · High Point, NCN64048Gray Peter A · Salinas, CAN6404JMorgan Donelle C · Cambria, CAN6404PNickell Paul D · Milo, IA
Back to AD 87-10-06 R1