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.
N7625PVfr2imc LLC · Elko, NVN7625SN4457s LLC · Southport, NCN7625WWings Up LLC · Manteno, ILN7626FJamestown Jet Center Inc · Jamestown, NDN7626LLester Androcles J · Ester, AKN7626PZervos Fredric W · Orland Park, ILN7626RBasinger Weston P · Alexandria, VAN7626WStiles Kenneth R · Ozawkie, KSN7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeN7627DVanhouse Daniel W · Topeka, KSN7627FLo Co Holdings LLC · Loudon, TNN7627NRanger Aviation Inc · Burlington, CON7627PKill Stephen W · Granbury, TXN7627RReising Douglas C · Caseyville, ILN7628LAerial Serveys Inc · Post Falls, IDN7628RWilson Rodney C · Flagstaff, AZN7628YLamantia Mark V · Ebensburg, PAN7629GDodd Dennis R · Collinsville, OKN7629JWatson Tony A · Rydal, GAN7629VMountain Air Spray Co · Craig, CON7629WMah Michael · Pittsfield, MAN762ALrh Equipment LLC · Pendleton, ORN762ABPlane And Simple Leasing LLC · Delano, MNN762ADKahle James H · Morristown, NJN762AMTippit Larry J · Arlington, TXN762BGBrumbaugh Aviation LLC · Lewes, DEN762BHViglierchio David R II · Davis, CAN762CMAnderson Daniel S · Payson, AZN762DHGo Mango LLC · Las Vegas, NVN762DRC & J Flying LLC · Rapid City, SDN762JMPridgen Michael E · Odenton, MDN762JRRohauer James D · Attica, NYN762JTPurdue University · West Lafayette, INN762KEGrasley Steven S · Green Cove Springs, FLN762KGDickens Randy L · Fuquay Varina, NCN762MMGraham Jimmy E · Morristown, AZN762NDUnd Aerospace Foundation · Grand Forks, NDN762PJTalcott James · Sutton, AKN762PSAlpine Veterinary Service Inc · Billings, MTFirst renewal noticeN762SASua 762sa Inc · Palm City, FLN762SMMyers Shawn Lee · Rincon, GAN762SSShetter Steven P · Chambersburg, PAN762SUAlmost There Air LLC · Daytona Beach, FLN762TRWood Eugene H · Hickory, NCN7630SKidd Alan E Trustee · Louisburg, KSN7630YJprg Aviation Inc · Orlando, FLN7631FMatthew E Richards · Southaven, MSN7631GChickadee Aviation LLC · Rangeley, MEN7631TBoyd James J · Alexander, NCN7631WDyer Troy · Wolcottville, IN
Back to AD 87-10-06 R1