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.
N66352Seaplane Adventures LLC · Cheyenne, WYN66354Chesson Bradley S · Tacoma, WAN6635BChandler Jerome P · Redondo Beach, CAN6635DGooderum Mark P · Excelsior, MNN6635JIndian Head Flying Club LLC · Indian Head, MDN6635PJohnston Robert J · Oro Valley, AZN6635UBistline Ladell J Sr · Colorado City, AZN6636DAnderson James M · Little Rock, ARN6636LAoa Kissimmee Inc · Kissimmee, FLN6636TVincent Air LLC · Carroll, IAN6636UBurcham Jaime S · Advance, NCN6636VMoss Herman D · Centreville, VAN6637JCaison Rodney D · Carrollton, VAN6637PEbner Rudy · Orange, TXN6638BAhmed Gedi A · Saint Paul, MNN6638HWright Aero Inc · Saint Cloud, MNN66399Acord Aviation Co L L C · Chandler, OKN6639DBig Bend Community College · Moses Lake, WAN6639JColoski Dennis J · Marlton, NJN6639PMustain Michael J · Monticello, GAN663ABBald Allan D · Alton, NHN663AFSnelling Peter G · Thornton, PAN663DHEmig Terry · Casa Grande, AZN663DXSouthtec Inc · Wilmington, DEN663GMMitchell David · Carrollton, GAN663NDUnd Aerospace Foundation · Grand Forks, NDN663RTRaiders Tigers Flying Club Inc DBA · Houston, TXN663RVPlaxco Mitchell O · Huntsville, ALN663SMMacmoyle Scott · Blairstown, NJN663WTSkywest Leasing Inc · St George, UTN66405Mh Aviation LLC · Foster City, CAN6640HSolis Aviation LLC · Carroll, OHN6640JHeesch Donald · Nunn, CON6640PAlexander Paul S · Selma, ALN6640VCarlsbad Raceway Corp · Hemet, CAN6640WAldrich David G · Naples, FLN6641JStratus Business Development LLC · Nashua, NHN6641PMartinous Shawn A · Providence, RIN6642JFive By Ten LLC · Loveland, CON6642UCrawford Daniel G Trustee · Dryden, MIN6642WBrown Kevin D · Saint Louis, MON6643JJohnson Steve · Attleboro, MAN6643WWeiss Stephan T · San Jose, CAN6644BN6644b LLC · Cresson, TXN6644MSierra Lima Aviation LLC · Riverton, UTN6644YN6644y LLC · Philomath, ORN6644ZKing Jonathan R · Palmer, AKN6645AAlmost There Air LLC · Daytona Beach, FLN6645JMcdonald Neill F Jr · Fairfax, VAN6645UFreemont Investors Inc · Bainbridge Island, WA
Back to AD 87-10-06 R1