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.
N6166DClb LLC · Boerne, TXN6166JBorder Steven C · Wharton, TXN6166MBradley Aero Services Inc · Southwick, MAN61670Registered aircraftN61671Charlotte Flyers Inc · Fort Myers, FLN61672American Patrols Inc · Midland, TXN61676Vectors LLC · Sterling, VAN61677Morcom Aviation Services Inc DBA · Everett, WAN6167KDuncan Marianna G · Lufkin, TXN6167LEastern Cincinnati Aviation Inc · Batavia, OHN6167PRico Nathaniel J · Astoria, ORN6167SHeaberlin Henry L · Corbin, KYN61680Kaye Linda · Grove, OKN61683Migdalski Randall C · Pembroke Pines, FLN61684Odyssey Aircraft LLC · Topeka, KSN61687Advanced Rehab Specialties Pa · Leesburg, FLN61689Bc 414 LLC · Los Angeles, CAN6168DMadison James E · Concord, CAN6168HWayne Air LLC · Collinwood, TNN6168SFerrell William W II · Flagstaff, AZN6168VYoung Martin H II · Rogers, ARN6168WSchwenning Donald R · Upper Sundusky, OHN6168XKey Daemon S · Lexington, TNN6168YIngalls Donald H · Morgan Hill, CAN61692Pittsburgh Institute Of Aeronautics · West Mifflin, PAN61696Bakker Margaret E Trustee · Petaluma, CAN61697L&W Aircraft Investment LLC · Homestead, FLN61699Erickson Steve · St Michael, MNN6169PKlier John M · Alpine, CAN6169RN999gk LLC · Nantucket, MAN6169YWiesen Enterprises Ltd · Empire, MIN616AADowns Kenneth · Houston, TXN616ACN616ac LLC · Westfield, MAN616ADArcher Aircraft LLC · Wilmington, DEN616AMMusson Brian D · Camas, WAN616AWAtd Pilot Training Lllc · Kansas City, MON616CGPeterson Colin C · Plano, TXN616CNN616cn LLC · Spencer, INN616DMMoorman Jesse David · Centerville, IAN616ESDiamond Larry Michael · Galax, VAN616FLFlight Gear Aviation LLC · Pickerington, OHN616HTWright S A Trustee · Cave Creek, AZN616JPWb Painting Contractors LLC · Greenville, MSN616JWWilkinson Dane W · Morgan, UTN616KCN616kc LLC · Conway, ARN616LYPanzer Jessica DBA · Lincoln, NEN616MCFletcher Flying LLC · Russellville, ARN616PCPork Chop Aviation II LLC · Hilliard, OHN616RHangar 21 Aviation Inc · Orange, CAN616RSHubert Richard A · Fowlerville, MI
Back to AD 87-10-06 R1