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.
N6125ZSvendsen Jon A · Wasilla, AKN61260Syracuse Flight School Inc · Syracuse, NYN6126DNeal Brian C · Monrovia, CAN6126MBishop Aeronautics LLC · Helena, MTN6126PDallas Jets Group LLC · Canton, TXN6126SWise Joseph · Kilgore, TXN6126TGuida Associates Consulting Inc · Sandpoint, IDN6126WMatthews James C · Gilbert, SCN6127AGilfert Thomas E · Selinsgrove, PAN6127HBless Howard P · Pennsburg, PAFirst renewal noticeN6127MOhman Victor N · Glenrock, WYN6127VSorbi Aviation Inc · El Cajon, CAN6127WLa Aviation Ltd · Wilmington, DEN6127ZSimmons Aviation Services LLC · Pawcatuck, CTN6128PTango Alpha Sierra LLC · Berthoud, CON6128TStone Mark · Scotts Valley, CAN6128UJoslyn Larry J · Las Vegas, NVN6129CSumner Scott B · Catoosa, OKN6129HHouk Air LLC · Waverly, OHN6129JBlue Skies Aircraft LLC · Kalispell, MTN6129LDodson David W · Granger, INN6129TTaf Aerial Services LLC · Beeville, TXN612APThomas Lucas G · Beebe, ARN612BZDerby City Aviation LLC · Vero Beach, FLN612EHIsland Flyers Inc · Addison, TXN612FTFlorida Institute Of Technology · Melbourne, FLN612GCareer Pilot Training LLC · Wilmington, DEN612GGMid Missouri Spray Service LLC · Richmond, MON612GPPlugge Glen A · Tuscaloosa, ALN612HPAmerican Patrols Inc · Midland, TXN612JLHeartland Aviation Inc · Alliance, NEN612JSWings Of Eagle LLC · Leo, INN612KSRv Co LLC · Boulder, CON612LCGoodman Lawrence A · Granbury, TXN612MRFladr LLC · Westfield, NJN612NPBirdpark Aviation LLC · Richmond, TXN612PAJenkins Phillip R Jr · Fuquay Varina, NCN612RTWolding Mylo D · New Town, NDN612TMMcdermott James Timothy · Newell, SDN612WTPlane Leasing LLC · Tempe, AZN612WWEhecatl LLC · Fort Wayne, INN612XMexico Medical Missions · Missouri City, TXN6130DJones Matthew A · Saluda, NCN6130JUtley Gary D · Okmulgee, OKFirst renewal noticeN6130PHiga Bertram · Northridge, CAN6130XSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6131JDotson Tem · Hindsville, ARN6131SClassic Rotors Museum · Ramona, CAN6132GMorcom Aviation Services Inc · Everett, WAN6132JWolf Aviation Network Inc · Westfield, MA
Back to AD 87-10-06 R1