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.
N9568Medic Choppers LLC · Springdale, ARN9568CMitchell Stephen D · Wichita, KSN9568GTakai Hiroyasu · San Jose, CAN9568JJeep Kenneth M · Wadsworth, ILN9568LD & S Aviation LLC · Spring, TXN9568MKinney William A · Missouri City, TXN9568URegistration Pending · Bath, PARegistration pendingN9568VAnderson Zachery D · Bigfork, MTN9568WSale Reported · Cimarron, KSSale reportedN95690Daly Arthur P · El Paso, TXN9569FClassic Helicopter Corp · Auburn, WAN9569HOsborn Larry R · Summerville, SCN956ACJpe Aviation LLC · Fairview, TXN956CFHighwind Aero LLC · Inyokern, CAN956CRCreamer Michael · Miami, FLN956DCLefthalfplane LLC · Kalispell, MTN956GTTargonski Gregory · Williamson, GAN956JBJ Robb Consulting LLC · Scottsdale, AZN956LBStark Robert C · Hillsboro, ORN956MAAllen William D · Tampa, FLN956MDDigit Aviation LLC · Hampton, NHN956PMSparks James D · Glennallen, AKN956RHHuston Ben E · Sanger, TXN956RVKemph Jeffrey A · Howell, MIN956SLLittle James S · Douglass, TXN956SPN3812q LLC · San Diego, CAN956TAAir Corriente LLC · Wilmington, DEN956TERaw Logistics LLC · Bethel, NCN9570AUpper Fifteen Inc · Latham, NYN9570JCharlie November Romeo LLC · Denver City, TXN9570UFranken Todd V · Martindale, TXN9570VAwp Holdings LLC · Murphysboro, ILN9571HWings Over Texas Holdings LLC · Denton, TXN9571JMeunier Barry · Rehoboth, MAN9571KOtter Fly LLC · Maricopa, AZN9571MSale Reported · Sacramento, CASale reportedN9571VTempleton John E · Loami, ILN9572AEagle Eye Marketing LLC · Reno, NVN9572HGeneral Aviation LLC · Henderson, NVN9572LJav Air Services LLC · Anchorage, AKN9572VHill Timothy E · Hooks, TXN9572WDr Equipment LLC · Ackerly, TXN9573Styer David B · Pendleton, ORN9573BDocarmo Aviation LLC · Dallas, TXN9573LCrosetto Pierre F · Downey, CAN9573MAndrews Geoffrey M · Stoneham, MAN9573PAerial Banners Inc · Pembroke Pines, FLN9573SOppegard Nicholas D · Eagle River, AKN9573VReynolds Darryl G · Wills Point, TXN9573WPyxl Sky LLC · Cogan Station, PA
Back to AD 87-10-06 R1