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.
N789CEBond Brent L · Clearwater, KSN789CMPierce Trey A · Tahlequah, OKN789DWFergus Falls Aviation LLC · Fergus Falls, MNN789EUnlimited Visibility LLC · Wilmington, DEN789FBHot Wings Aviation LLC · Fishers, INN789FGSolf William · Winnett, MTN789FRRegistration Pending · Brookshire, TXRegistration pending, pending cancellationN789GRH Richardson & Sons LLC · Ogdensburg, NYN789GTJj Hughes Logistics LLC · Canyon, TXN789JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INN789JFCoordinated Turn LLC · Fort Worth, TXN789JMMathews John D · Fallbrook, CAN789JNChandelle Co · Marion, IAN789JRMascheroni Andre R · Mccall, IDN789LHJones Aircraft Company LLC · Cross Plains, TNN789MAS D 789 Partners LLC · Batavia, ILN789MHHenderson Michael E · Edmonds, WAN789NDUnd Aerospace Foundation · Grand Forks, NDN789PZarski Rebecca Cross · Sharon Springs, NYN789PALong Jacob · Jupiter, FLN789PBFrederick Charles Edward · FreeportNon-citizen corporation, flight hours not reportedN789RAMiller Melanie L · Spanaway, WAN789RLBlacktiger LLC · Wilmington, DEN789SVPaulukaitis Robert Adam · Hudson Oaks, TXN789TBKelly Derrell R · Truman, MNN789TCMadden Contracting Co Inc · Minden, LAN789UTradewinds Aero Inc · Traverse City, MIN789WEStoked Aero LLC · Camas, WAN789WMRegistered aircraftN789WTGabrys Ronald B · Wisconsin Rapids, WIN78AARw Higginsllc · Armuchee, GAN78AJHamlin Curits · North Pole, AKN78ATSchrage Rodney L · Steamboat Springs, CON78BGKdrd Holdings LLC · Texas City, TXN78BYNorthwestern Michigan College · Traverse City, MIN78CWPotter Justin D · Eagle River, AKN78DFBurkett Robert S · Baytown, TXN78DJKing David V · Mars, PAN78EFFearnow Rolland E · Wabash, INN78EHN78eh Management LLC · Lewes, DEN78FLFlight Levels LLC · Ridgeland, MSN78FMFraker Gregory M · Plymouth, MIN78GBJones Richard · Cornville, AZN78GCMh Aviation LLC · Foster City, CAN78GHCustom Air International LLC · Homestead, FLN78GPBailey Eric C · Lake Havasu City, AZN78GSAir Mods And Repair Corp · Robbinsville, NJN78GTBennett Wayne M Jr · Puyallup, WAN78HBValiair Lc Trustee · Casper, WYN78HYD A Lamont Public Adjusters LLC · Springtown, TX
Back to AD 87-10-06 R1