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.
N7803GTomlin Jonathan S · Georgetown, OHN7803PNoguess James E · Deming, NMN7803VArtlip James · Wake Forest, NCN7803W3w Group Inc · Hot Springs, ARN78048Latham Randall W · Georgetown, OHN7804GWells Adam · New Lexington, OHN7804NApaa Aviation Group LLC · Frisco, TXN7804PFisher B Barton · Bowman, NDN7804VVickers David Dewayne · Douglas, GAN78051Sipple Ronald W Jr · Gardner, KSN7805DMoretti Anthony · Deming, NMN7805GArgabright John · Waterford, OHN7805NCorrigan Air Center · Hondo, TXN7805PN6760s LLC · Brooklyn, NYN7805YN7805y LLC · Winchester, VAN78066Orlandi Properties LLC · Blairstown, NJN7806DHillegeist Tracy L · Beverly, KSN7806GAircraft Management Services Inc · Milton, FLN7806NTab Air Time LLC · Longmont, CON7806PSpires Kenneth G · Seville, OHN7806VMouriz Javier · Leesburg, FLN7806YHhozapnv-LLC · Las Vegas, NVN78074Bartholomew Donald B · Gardnerville, NVN78076Clinton Aeroclub · Clinton, IAN78078International Air Services Inc Trustee · Carson City, NVN7807GLake Of The Woods Aviation LLC · Baudette, MNN7807NBwh Leasing LLC · Lewes, DEN7807SSmith Travis T · Watsonville, CAN7807VMad Dog Aviation LLC · Minot, NDN7807YMcv2021 LLC · Saint Augustine, FLN78083Holcomb Garry · Point, TXN78086Drake Ronald N · Helena, MTN7808VWalker Trenton A · Pittsburg, OKN7808YKleiner Daniel S · Aliso Viejo, CAN7808ZWiedeman Matthew A · Batesville, INN78095Leuer James A · Encinitas, CAN7809GHodge Aviation LLC · Monroe, LAN7809NUninsured Justice Enterprises LLC · Joplin, MON7809SJo Ann Miller Marshall · Atlanta, GAN7809WHand Lawrence E · Klamath Falls, ORN780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYN780BGMaw Enterprises USA LLC · Hudson, FLN780DAFawley Dean · Newnan, GAN780DMTexas Barnstormers LLC · Rogers, TXN780GAPrairie Planes LLC · Mitchell, SDN780GCAir Eye Md LLC · Carolina, PRN780GWSchreiber-Beck Cynthia K · Wahpeton, NDN780LAN780la LLC · Philadelphia, PAN780NWBarthold David Keith · Gainesville, TXN780SN780s LLC · Williamstown, NJ
Back to AD 87-10-06 R1