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.
N8117ZOaces Aero Holdings LLC · Santa Rosa Beach, FLN81181Registration Pending · Sacramento, CARegistration pendingN81182Couch Sherman R · West Chester, OHN81183Registered aircraftN81188International Air Services Inc Trustee · Carson City, NVN8118NSingleton Aviation LLC · Houston, TXN8118QDakota Aviation Corp · Sayville, NYN8118SMorgan Michael E Trustee · Redding, CAN8118TSmith David · Montvale, NJN8118WHenson Anthony · Jasper, ALN8118XSchultz Robert J · Rapid City, SDN8118ZWest Metro Aviation LLC · Buffalo, MNN8119BChabrier Pierre H · Wesley Chapel, FLN8119CHenry Gary A · Narragansett, RIN8119EMorse Daniel D · Edinburg, TXFirst renewal noticeN8119HPiper Warrior LLC · Middleton, MAN8119PStelling William F · Fairbury, NEN8119QBay Lux Ventures LLC · Tampa, FLN8119YStar H Aviation LLC · Plano, TXN811AFState Of Louisiana · Baton Rouge, LAN811AJScarrow Justin · Palmer, AKN811ASS&A Flying LLC · Minden, NEN811ATDot Aviation LLC · Wilmington, DEN811BJSix Pack Aviation LLC · Pocono Pines, PAN811BLWingsleasing LLC · Wichita, KSN811CBRfw Construction Group LLC · Dyersburg, TNN811CPCivil Air Patrol · Maxwell Afb, ALN811DHRegistered aircraftN811DWPerucca Douglas E · Wasilla, AKN811EBBanks Cecil E Jr · Dayton, NVN811GSTri-Delta Design LLC · Cedar Park, TXN811GWGreat Western Aviation Leasing LLC · Ogden, UTN811HATate Grady · Harrisburg, NCN811JBGaskin Aviation LLC · Tallahassee, FLN811JDSanders Jason C · Babylon, NYN811LESmith Colin B · San Diego, CAN811LWWeaver Savannah N · Elmore, ALN811PJObrien Neal J · Milton, GAN811PMMcdaniel Erick R · Fort Worth, TXN811RFMapes Neal E · Prineville, ORN811RMForero Christopher · Mercerville, NJN811RVMorgan Matthew P · Gainesville, GAFirst renewal noticeN811SSmith Helicopters Inc · Cotulla, TXN811SEAdams Jonathan O · Columbia, MON811TTJordison Investments LLC · Auburn, WAN811TWNova Aircraft Holdings Inc · San Diego, CAN811VClayton Camden Logan · Pensacola, FLN811WCampbell Larry L · Fort Mill, SCN811WJNear William J · Weirsdale, FLN811YDRiser Aviation LLC · Foley, AL
Back to AD 87-10-06 R1