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.
N8435FRed Tail Scholarship Foundation · Tuskegee, ALN8435G303 LLC · Beaumont, TXN8435HKadac LLC · Shawano, WIN8435LAarow Aircraft Leasing LLC · Mcminnville, ORN8435UMayotte Robert · Boynton Beach, FLN8435YGlobal Aviators Academy Inc · Claremont, CAN84364Innovated Control Systems Inc · Watsonville, CAN84365Abbott Troy D · Hollywood, MDN84366Noeldner Pamela Ann · Lansdale, PAN84367Martin Arthur D · New Market, VAN84368N84368 LLC · Colorado Springs, CON84369Ulrich Casey M · Waldo, KSN8436JMarshall Lee C · Hartsville, SCN8436RRegistration Pending · Riverton, KSRegistration pending, pending cancellationN8436TElias Akal Aviation LLC · Deering, NHN8436WHidalgo Robert J · El Paso, TXN8437CRobert Price Smith · Hodgenville, KYN8437DClark Donald S · Atlantic Beach, FLN8437WThomas Eric D · Placerville, CAN84386Bell Motor Co · Cut Bank, MTN8438EBohlen Terry A · Cameron Park, CAN8438HPitt Ian · Bergenfield, NJN8438RMorrison Doyle T · Goldthwaite, TXN8438YJohnson Aaron D · Colfax, WAN84390Butts Desmon D · New Waverly, TXN84391Vicknair Michael N · Owasso, OKN84392Romeo Flying Club LLC · Leonard, MIN84397Hernandez Karen K · Garden Valley, CAN8439EManchin Joseph III · Charleston, WVN8439MSteel Supply Co · Rolling Meadows, ILN8439TFly Quest Aviation LLC · Pomona, CAFirst renewal noticeN8439WPace Andrea · Homosassa, FLN8439YTracy Bill E · Leoti, KSN8439ZSyracuse Flying Club Inc · Fayetteville, NYN843DCJuliet Echo LLC · Sheridan, WYN843DPChoice Aviation LLC · Hamilton, MTN843FRC4l Helicopters LLC · Myrtle Beach, SCN843GR & B Aircraft Holdings LLC · Denham Springs, LAN843RFConner Patsy L · Kerrville, TXN843SCFf22 LLC · Scottsdale, AZN843SDAftab Younus · Pleasanton, CAN843TCLegends Air Center LLC · Bentonville, ARN844Ross George W DBA · Boise, IDN84400N84400 LLC · Chamblee, GAN84408Miyamoto Edward · Rio Vista, CAN8440BKoon Anthony Scott · Kokomo, INN8440DAkn Inc · Crystal, MNN8440HMeyer Anthony R · Whittemore, IAN8440LRoot William L Trustee · Scotia, NEN8440MAirflair Inc · Maurice, IA
Back to AD 87-10-06 R1