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.
N8689NHewitt Donald R · Califon, NJN8689VZacheis Henry M · Fairbanks, AKN8689YBlue Sky Aviators LLC · Winnebago, ILN868BBahrns Phyllis Alyene · Effingham, ILN868JDBratton Charles M · Gatesville, TXN868KWeber Jennifer R · Bryan, TXN868KFSmith Jason · Calliham, TXN868MMUhl Gregory R · Columbus, MSN868PProfessional Training Aircraft LLC · Wilmington, DEN868PKYellow Therapy LLC · Kalispell, MTN868RTMartin John D · Billings, MTN868SAS O W Aviation LLC · Crystal River, FLN868TCDlg Enterprises LLC · Iota, LAN868UInter American University Of Puerto Rico · Bayamon, PRN86901Rudderow Preston Trustee · Anchorage, AKN8690POrmsbee Bowden · Longmont, CON86911Schneberger Bart A · Nome, AKN86919Latham Ray H · Raymond, WAN8691PBagwell Robert B · Sequim, WAN8691YVan Bladeren John A · Tigard, ORN86928Collum Aviation LLC · Milton, FLN8692DBryan Kirk J · Big Timber, MTN8692PKuyoth Christopher J · Lake Orion, MIN8692VLohr Martin J · Petersburg, AKN8692YTedder Ag Technologies Inc · Walsh, CON86936Lewis Aviation Inc · Wilmington, DEN8693VMichael A Levenhagen · North Fort Myers, FLN8693WPack Timothy W · Blacklick, OHN8693YPeregrine Aviation LLC · Winfield, ILN86948Guglietta Jon R · Harwinton, CTN8694DJunek John M · Leonardtown, MDN8694NCitadelle Holdings LLC · Palmetto Bay, FLN86950Dale Jane L · Willow, AKN86953Madden Russell · Graford, TXN86954Breaking Wind LLC · Alabaster, ALN86957Swan Creek Flying Club · Ayr, NDN8695PDurflinger Aviation LLC · Otterbein, INFirst renewal noticeN8695WBurr Walker · Redmond, UTN8695YPurkinje Ltd LLC · Wilmington, DEN86968Crafted Enterprises LLC · Montrose, CON86969Sperry Sails Inc · Marion, MAN8696VMoynahan Thomas F · Newnan, GAN86974Qualitair LLC Trustee · MichelstadtN86977Ajs Aviation Inc · Spring Hill, FLN8697EMaze Bryan · Tulare, CAN8697LFried Stephen · Kingston, MAN8697VFisher Kurt Adrian Trustee · San Luis Obispo, CAN86985Thomas Lucas G · Beebe, ARN86986Nelson Michael R · Philip, SDN86989Webb Terry M · Montreal, MO
Back to AD 87-10-06 R1