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.
N88GKSale Reported · Crestview, FLSale reportedN88GRLewis Brad D · Eugene, ORN88GT9q Partners LLC · West Caldwell, NJN88GVAllen Timothy J · Petersburgh, NYN88HLLiberty Aero LLC · Carlsbad, NMN88JCFarooq Tayab · Allen, TXN88JLSummit Concepts Inc · Wilmington, DEN88JVVan Grunsven Gerald B · Hillsboro, ORN88KAStefenelli Aviation N-Tr Inc Trustee · AtterseeN88KCMccarty Lyle H · Eugene, ORN88KFFore Shannon R · Wasilla, AKN88LDBryan William R · Kennesaw, GAN88LLLarrabee Consulting Group LLC · West Carrollton, OHN88LWRkj Enterprises · Bay City, TXN88MDWaage Matthew L · Elkhart Lake, WIN88MHCaitlyn Aviation LLC · Thousand Oaks, CAN88MRMarkus Stanley L · Oconomowoc, WIN88NPRegistration Pending · Saint Petersburg, FLRegistration pendingN88NSDaniel Timidaiski · Mukilteo, WAN88PGBoyer Joseph A · Knoxville, TNN88PV400 Aviation LLC · Elkhart, INN88PYSegler Max D · Shoreview, MNN88PZ88pz LLC · Clifton Park, NYN88QBAckerman Mendel R · Saint Matthews, SCN88QQJprg Aviation Inc · Orlando, FLN88RARusso Mark · Stevensville, MTN88RDLafayette Flying Service LLC · Lafayette, LAN88RFGrant Joseph P · Priest River, IDN88RHKeystone Flyer LLC · Avon, INN88RVMyers Thomas A · Yamhill, ORN88RWRhoads Timothy C · Logan, NMN88SAAbc Aviation LLC · Oakland, CAN88SHSmith Jeary K · Greenfield, INN88SSWasson Trevor J · Whitewater, MTN88SWBoline Lonny R · Lincoln, MEN88SYYamashita Bruce · Honolulu, HIN88TFHarts Joel D · Coffeyville, KSN88TGMakushin Logistics LLC · Fairbanks, AKN88TLAh Legacy LLC · Orlando, FLN88TURv There Yet ? LLC · Lewes, DEN88UMSchefer Charles W L · Warrenton, VAN88VBBjelland Richard A · Galt, CAN88VLMccullough Peter M · Evansville, INN88WCClobes Warren J · Evansville, WIN88WHThomas Robert R · Rochester, MNN88WPN88wp LLC · Magnolia, TXN88WSChamberlain Donald R · Simsbury, CTN88WWQwest Aviation LLC · Edwardsburg, MIN88XKN-88xk Medical Aviation LLC · Kalispell, MTN88XTHallett Charles R · Fisherville, KYFirst renewal notice
Back to AD 87-10-06 R1